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

ID: Q69670

The information in this article applies to:

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        :

Last Reviewed: March 22, 1999