Home |
Search |
Today's Posts |
#4
![]() |
|||
|
|||
![]()
To show numbers as currency, you can apply either the Currency format or the Accounting format.
Select the cells that you want to format and then, in the Number group on the Home tab, click the down arrow in the Number Format box. Choose either Currency or Accounting. Currency With this format: The decimal points appear aligned in the column. The currency symbol appears next to the first digit in the cell. (That is, it is not aligned with the other currency symbols in the column. I hope this helps! Tim Paine |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
convert number to words(like 1.00 = Dollar One Only) | Excel Worksheet Functions | |||
Question For Importing Data Into Excel/Converting General Number to Dollar Amount | Excel Discussion (Misc queries) | |||
Converting currency from US Dollar into Canadian dollars from column A to Column B | Excel Worksheet Functions | |||
How do I align numbers where one number has a dollar sign? | Charts and Charting in Excel | |||
Converting 100 cents to 1 dollar | Excel Worksheet Functions |