Microsoft KB Archive/69670

{|
 * width="100%"|

Excel: Custom Number Format to Align Dollar Sign to the Left

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a, 5.0

-

SUMMARY
In Microsoft Excel, if you want the dollar signs ($) of a number to align to the left, use the following number format:

  _($* #,##0.00_);($* #,##0.00)

This format displays the following types of numbers in a column:

   $    1.00 ($  10.00)    $  100.00    $1,000.00

Notice that the &quot;$&quot; is aligned in each cell.

MORE INFORMATION
The &quot;_(&quot; and &quot;_)&quot; on the positive part of the format allows for the extra space of a parenthesis. This aligns the number with the negative format, so that the decimal point will align correctly.

The &quot;$&quot; in the format above places the dollar sign in the display. The &quot;* &quot; (notice that there is a space after the asterisk) repeats the blank spaces enough to fill the column width. The &quot;#,##0.00&quot; displays value using at least one integer and two decimal places.