Display -123 as (123)

[Jeffry Huelse]

How do I display -123 as (123). I have done the calculation =(c32-c34) and
I want the negative number I just want it displayed with parentheses rather
then the minus symbol. Any help would be appreciated.

Thanks

JR

 

[Nick Hodge]

Jeffry

Formats consist of four parts separated by ; the first is for whole numbers
the second for negative numbers, the third for zeroes and the last for text,
so via Format>Cells...>Custom, you could enter something like

0;(0);0

Obviously if you want decimals then

0.00;(0.00);0.00

Check out here or help on formatting codes

http://www.nickhodge.co.uk/gui/formatmenu/cells.htm

You can also change this globally using the settings in windows regional
settings

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)