View Single Post
  #4   Report Post  
Tim Paine Tim Paine is offline
Junior Member
 
Posts: 27
Default how to convert numbers to dollars in excel

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