Negative numbers in Excel 2003 - how to display these in brackets

By Sue H1 ·
There is no option for brackets in the format numbers screen (even if the number in the cell is negative)

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Answers

Collapse -

Try this

by LocoLobo In reply to Negative numbers in Excel ...

In 'Format Cells' choose custom, type in:


or if you want it red:


If that's the wrong bracket:


that should give you the idea.

Collapse -

Negative numbers in brackets in Excel 2003

by Sue H1 In reply to Try this

Many thanks. Is there a way I could have worked this out/should have been able to work this out for myself?

Collapse -

What I did

by LocoLobo In reply to Negative numbers in brack ...

was to go into the "Format Cells" dialog, choose "Custom" and experiment. In particular I would click on an option and look at how it formatted the number. After a while I observed that you could change the parentheses and color for negative numbers.

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums