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”). Format dates, currency, and more in Pages on Mac
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |