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

ID: Q69670

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 "$" is aligned in each cell.

MORE INFORMATION

The "_(" and "_)" 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 "$" in the format above places the dollar sign in the display. The "* " (notice that there is a space after the asterisk) repeats the blank spaces enough to fill the column width. The "#,##0.00" displays value using at least one integer and two decimal places.

REFERENCES

"Microsoft Excel User's Guide 1," version 4.0, pages 220-227

"Microsoft Excel User's Guide," version 3.0, pages 188-194

Additional query words: 3.0 4.0 currency justify

Keywords : xlformat
Version : 5.0
Platform :
Issue type :