Parenthesis for negative numbers

  • Thread starter Thread starter David H
  • Start date Start date
D

David H

In Excel 2002 I cannot find how to make negative numbers
with parenthesis (123), instead of the negative sign
-123. I go to Format-Cells-Accounting or Currency, but
its not there. I believe it is in the earlier versions of
Excel but not in 2002.
 
Thanks Frank, but I don't have 0.00,(0.00),0.00 in my
custom format in excel 2002, or can't find it
 
Format|Cells and select either Number or Currency. In Excel 2002 (same
in other version, as I recall), there are three selection items on the
right side of the dialog; the bottom of the three is how to handle
negative numbers, and the bottom two choices use parentheses for
negative numbers.

Jerry
 
Hi Jerry
think this depends either on the regional settings or the localization
of Excel. e.g. in my German version parenthesis are not an option in
this dialog
 
Back
Top