vert line
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.
Date Int'l 2 displays date serial number in the format MM/DD.


Time Int'l 1 displays the time portion of date serial number in the format HH:MM:SS.
Time Int'l 2 displays the time portion of date serial numbers in the format HH:MM.

See also

 

Also go to:

Index help

Contents help