Negative Number Display -- need Brackets
Either use the shortcut Ctrl + 1 (not 1 on the numpad) and select
accounting, or click the general drop down on the home tab and select
accounting, or right click the cell(s) and select format cells and select
accounting or use a custom format
_($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)
I personally dislike 2007 but formatting is certainly not changed or hidden
--
Regards,
Peo Sjoblom
"Rinke Gill" wrote in message
...
I would like my negative numbers in Excel to display in brackets. This is
what the "accounting" category under "format cells" allowed us to do in
the
2003 version. I cannot find a way to do this under any of the category
options in "format cells". It is driving me nuts, please help if anyone
knows!
If there is no such option, please update excel 2007 to include this. It
is
very important to have this function for us accountants!
--
Rinke
|