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

 Last reviewed: May 21, 1997
Article 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: 5.00 3.0 3.00 4.0 4.00 currency justify
Keywords : xlformat kbusage
Version : 5.0

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 21, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.