MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Displaying negative numbers with brackets around


Posted by Trevor Sharp on September 05, 2000 2:56 PM

In the good (yawn!) ol' days you could get Excel to display negative numbers with brackets around to flag up the fact they were negative. (The negative number is a bit small) How can I do it on Excel 97?


Posted by Ivan Moala on September 06, 0100 1:16 AM

In the custom number format enter this;
#,##0;(#,##0);0

Format / Cells / Number and select Custom
to enter the above.


Ivan

Posted by P Doughboy on September 06, 0100 1:20 AM

Can't think of anything offhand unless you are willing to use parens.
That is pretty easy.

How complicated do you want to get?
using if statements or macros. anything can be done if you want it bad enough.

Unless anyone else knows.

Posted by Tim Francis-Wright on September 06, 0100 8:48 AM

If you want brackets [ ] instead of parens,
modify Ivan's format to: #,##0;\[#,##0\];0

You need the backslashes because Excel normally
uses brackets for conditions.

HTH