Microsoft KB Archive/66762

{|
 * width="100%"|

Excel: Number Format to Align Dollar ($) Signs

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0
 * Microsoft Excel for OS/2 versions 2.2, 2.21, and 3.0

-

SUMMARY
The following format will align the dollar signs ($) vertically:

  $* #,##0.00

By default, Microsoft Excel places the $ right next to the number. In the format above, the asterisk after $, followed by a blank space, tells Excel to fill the cell with spaces (where there are no numbers) and aligns a &quot;$&quot; farthest to the left.

For example:

      Without Format                           With Format --                          ---

A                                      A   1 |       $123.49|                      1 |$       123.49| 2 |   $56,234.99|                      2 |$    56,234.99|   3 | $1,748,001.72|                      3 |$ 1,748,002.72|   4 |         $0.21|                      4 |$         0.21| Additional query words: 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0 4.0 currency

Keywords :

Version :

Platform :

Issue type :

Technology :