|
![]() |
![]() |
Use
the Sheet Inspector to change the number or date display format for the
entire sheet.
Use the Cell Format Inspector to change the number or date display format for the selected range. Most items apply only to cells with a number value. Exceptions are the Text and Hidden formats. Options The decimal selector changes the number of decimal places displayed when Fixed Decimal, Scientific, Currency, Comma, and Percent formats are selected. Text Format. The Text format displays the input of the cell. If a cell has a formula, the formula - not the calculated value - is displayed. Hidden Format. The Hidden format displays nothing in the cell, as if the cell is blank. This format can be used to hide intermediate results that would otherwise clutter the worksheet. Date Formats Date Int'l 1 displays
date serial numbers in the format MM/DD/YY.
See also |
||
|
||