Formatting

E

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.
 
C

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
 
M

Mark Graesser

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
[email protected]
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
 
D

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
 
Top