Display -123 as (123)

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

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


"Jeffry Huelse" <[email protected]!> wrote in message
news:[email protected]...
> 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
>
>