If you want to display numbers as monetary values, you must format those numbers as currency. To do this, you apply either the Currency or Accounting number format to the cells that you want to format. The number formatting options are available on the Home tab in the Number Format box.
Format numbers as currency
Select the cells.
On the Home tab, in the Number Format box, select Currency.
On the Currency menu, select the currency symbol that you want.
Note: For information about how to type the euro sign (€) in a cell, see Keyboard shortcuts for the euro currency symbol.
Change the position of the currency symbol
There are two ways to change the position of the currency symbol:
The regional settings for currency determine the position of the currency symbol. The symbol can appear before or after the number, and there can be a space separating the symbol and the number. The regional settings also determine the decimal symbol and the thousands separator. You can control these settings by using the Mac OS X Language & Region system preferences.
If you want all the currency symbols to line up, select Accounting, rather than Currency in the Number Format box.