Excel 2000 brackets on negative numbers

  • Thread starter Thread starter sandy
  • Start date Start date
S

sandy

On Feb 11/04 I put out a call for help with brackets on
negative numbers...Gord Dibben replied to say go out to
set regional settings...I have done this and brackets
still don't show up...I even rebooted the PC...any other
suggestions.
 
Have you tried a Custom number format?
Format, Cells, Custom.
There is probably a suitable option in the list. Check OLH for formatting
instructions, but something like:

#,##0.00_);[Red](#,##0.00)

should do. Explanation
To the left of the semi-colon is the format for positive numbers
"_)" indicates that the number is padded at the right end to line up
with a bracket in another element of the format
To the right of teh semi-colon is teh format element for negative numbers:
[Red] instructs the font colour
Brackets either side indicates brackets required

#,##0.00 indicates zeroes to be displayed for Units & 2 decimals
Other numbers only as relevant
comma as thousands separator
 
Back
Top