Currency Format Causes Alignment Problems in ExcelID: Q68416
|
When you use the currency format, formatted numbers may not align flush
right.
All currency formats, for example, $#,##0_);($#,##0), have a space
between the first 0 and the semicolon as a default setting. This space
is created by an underscore and any character (in this example a closing
parenthesis) after the final zero in the first number in the format.
The additional space keeps negative and positive numbers aligned correctly
when negative numbers are enclosed in parenthesis.
For example:
Default format (with space) $495.00
($495.00)
Revised format (without space) $495.00
($495.00)
To change the currency format setting so that the formatted cell is
flush right, do the following:
#,##0.00_);(#,##0.00)
#,##0.00;(#,##0.00)
"User's Guide," version 5.0, pages 210-214
"User's Guide 1," version 4.0, pages 106-110
"Microsoft Excel User's Guide," version 3, pages 90-96
Additional query words: 3.0 4.0 4.00a
Keywords :
Version :
Platform :
Issue type :
Last Reviewed: March 21, 1999