View Single Post
  #4   Report Post  
Old December 31st 20, 02:16 PM
Tim Paine Tim Paine is offline
Junior Member
 
First recorded activity by ExcelBanter: Dec 2020
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