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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why doesn't my Excel '03 let me use brackets for negative numbers 2
Bracket negative numbers 3
lost the ability to bracket negative numbers 3
Excel 2007, show negative in my financial statements in brackets? 1
How do I show negative number in brackets using excel? 3
I cannot get Excel to put negative amounts in brackets. Help ! 6
Displaying negatives with (brackets) 3
Excel 2000...brackets on negative numbers 3

Back
Top