When formatting numbers, there is a difference between Accounting and Currency formatting. In the earlier versions, the $ icon displayed Currency but it formatted as Accounting. Under the Format Cells NumberWhen applying the formatting here is what you need to remember:

  • Accounting starts with the letter “A” and that means the dollar symbol is “away” and “align” left from the numbers.  For example:
$                    2,000.00
$                      1,00.89
$                          56.99
  • Currency starts with the letter “C” and that means the dollar symbol is “close by”
    For example:

$2,000.00

$1,000.89

$56.99

Advertisements