Microsoft Office Tutorials and References
In Depth Information
Formatting as you type
Figure 9-32 Click the dialog box launcher in the Number group to display the Number tab of
the Format Cells dialog box.
Figure 9-33 You can format individual characters within a cell.
Formatting as you type
You can include special formatting characters—such as dollar signs, percent signs, commas,
or fractions—to format numbers as you type them. When you type numeric-entry
characters that represent a format Excel recognizes, Excel applies that format to the cell on the fly.
The following list describes some of the more common special formatting characters:
If you type $45.00 in a cell, Excel interprets your entry as the value 45 formatted as
currency with two decimal places. Only the value 45 appears in the formula bar after
you press Enter, but the formatted value, $45.00, appears in the cell.
Search JabSto ::

Custom Search