Formatting

[Excel user Irl]

Hi,

Can anybody tell me if it is possible to format a cell so
that a negative number will automatically appear in
parenthesis. Need urgent answer please.

 

[Charlie]

Highlight the desired cell, goto Format/Cell and pick
Number. Choose one of the selection on the right, either
(1234.10) in black or in red.

Charlie O'Neill

 

[Guest]

Hi Irl
You can use any of the numerous custom number formats, where the format style after the ; is in parenthesis. Go to Fomat>Cells>Number>Custom

Good Luck
Mark Graesse
(e-mail address removed)
Boston M

----- Excel user Irl wrote: ----

Hi

Can anybody tell me if it is possible to format a cell so
that a negative number will automatically appear in
parenthesis. Need urgent answer please

 

[David McRitchie]

Hi Mark,
What version of Excel, what edition (US/International/??)
and what Regional setting are using.

I think there is a setting where you don't see all the options
for number formatting. If you have to do use Custom, the following
may be of some help until you can find out what is missing. .
http://www.mvps.org/dmcritchie/formula.htm#numberformat

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm