Set the number of decimal places: In the Decimals field, type the number of decimal places you want to display. Number: Displays standard number formatting. In the Format sidebar, click the Cell tab.Ĭlick the Data Format pop-up menu and choose an option: Select the cells or table you want to format. For example, if you change a number in a cell to a percentage, the number of decimal places displayed doesn’t change. You can change this setting so that all cells formatted as numbers display the same number of decimal places.Ĭhanges to decimal settings apply to both numbers and percentages. For example, if you have a table of prices, you can add a currency symbol (for example, a dollar sign $) to cells by formatting them as currency, then selecting the symbol you want.īy default, cells formatted as numbers display as many decimal places as you type in them. You can change a cell’s format even if you already typed content in the cell. When a formula refers to text in a cell, the displayed value is used in the calculation. The actual value entered is always used in calculations, regardless of how many decimal places appear in the cell. You can also choose how many decimal places appear in cells that contain numbers, currency units, or percentage values, even if the exact value entered in the cell is more precise than what you want to show. The cell format determines how data in the cell appears and how cell data is recognized by formulas that refer to that cell. You can format table cells to display text, numbers, currency, percentages, date and time, and durations denoting a span of time (for example, “3 weeks 4 days 2 hours”). If you can’t remove something from a documentįormat dates, currency, and more in Pages on Mac.Restore an earlier version of a document.Save a large document as a package file.Export to Word, PDF, or another file format.Change the look of chart text and labels.Add a legend, gridlines, and other markings.Change a chart from one type to another.Calculate values using data in table cells.Select tables, cells, rows, and columns.Fill shapes and text boxes with color or an image.Set pagination and line and page breaks.Format hyphens, dashes, and quotation marks. Format Chinese, Japanese, or Korean text.Use a keyboard shortcut to apply a text style.Create, rename, or delete a paragraph style.Bold, italic, underline, and strikethrough.Select text and place the insertion point.Use VoiceOver to preview comments and track changes.View formatting symbols and layout guides.Intro to images, charts, and other objects.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |