Number Formats in Excel

Even wonder when you are formatting numbers in Excel what is the difference between the Currency and the Accounting options? After all, they both place the $ symbol next to a number or a value.

The Accounting option will align the $ symbol to the left of the cell; therefore, if you have an entire column formatted in accounting style, all the $ symbols will be aligned in a straight line.

The Currency option places the $ symbol next to the number.