Microsoft Office Tutorials and References
In Depth Information
Currency and Accounting
Figure 11-8 In addition to setting the number of decimal places and showing or hiding the
1000 separator, you can choose how negative values are displayed.
Currency and Accounting
Both the Currency and Accounting formats are designed for use with values that represent
money. The difference? Currency formats allow you to choose an alternate format for
negative numbers (a minus sign, parentheses, or red font formatting). Accounting formats line
up decimals and move currency symbols to the left edge of the cell for a neater display in
reports. The alignment used in Accounting formats can be hard to read in wide columns
that contain small numbers; for readability’s sake, choose a Currency format for those
If you enter a number preceded by a dollar sign, Excel applies the Currency format, using
the default currency symbol with up to two decimal places, regardless of how many
decimal places you enter. Confusingly, when you click the command represented by a dollar
sign in the Number group on the Home tab, Excel actually applies the Currency cell style
(the Accounting format, with two decimal places). A drop-down list on this command
allows you to pick an alternate currency symbol—Euro, pound, and so on.
Search JabSto ::

Custom Search