MrExcel Publishing
Your One Stop for Excel Tips & Solutions

number formatting

Posted by Hal on January 17, 2002 8:55 AM

I want cells containing negative numbers to display
those numbers in brackets.I have always used
the ,(comma) format to do this. Excel 2000 dosen't
give me the brackets though spreadsheets created in 97
and used in 2000 does! How can I display negative
numbers in brackets? Help would be appreciated
Thanks, H

Posted by Russell Hauf on January 17, 2002 9:38 AM

I'm assuming that by brackets you mean parentheses. If so, go to FORMAT-CELLS, click NUMBER, and then choose either the 3rd or 4th option.

Hope this helps,


Posted by Mark W. on January 17, 2002 9:39 AM

General;\[-General\] (nt)

Posted by Hal on January 17, 2002 7:09 PM

Only options in Numbers format is -1234twice each in black and in red

Posted by Hal on January 17, 2002 7:10 PM

Re: General;\[-General\] (nt)

What do I do with General etc.? Be gentle!