Excel 2007 - display negative numbers with minus sign and parenthe
Answered it myself. Went into Regional and Language Options, Customize this
format.
But first time I had just changed the negative value on the Numbers Tab
But changed didn't show up in Excel
Went back in and on the Currency Tab, changed the negative number format
there as well.
Reopened Excel now have the format options with parathesis.
Guess needs to be set on both Numbers and Currency tabs for it to show in
Excel properly.
"Nadine" wrote:
Excel 2007 - display negative numbers with minus sign and parentheses
We go into format cells - select number - and there are only black or red
choices with or without a minus sign. Don't have any of the choices with
parentheses,
In excel 2003 have choices with parentheses in format cells - number
Is this feature gone in Excel 2007, search help and the help says - with or
without paretheses, but when following instructions there are no options for
parentheses are showing.
OS is Vista Enterprise
|