Need () around whole Numbers

[joker007]

Ok guys and gals this is what I have. I need to put () around whole numbers
and negative numbers need to read out normal. Here is an example.

12 would read out as (12)
-12 Would read out as 12
Here is a example:
If A1 was 12 and A2 was -13 A3 would = 1
and if
A1 was 12 and A3 was -4 A3 would = (8)

A3 = A1+A2

Thanks

 

[MartinW]

Hi,

Try a custom format of (#);#;;

HTH
Martin

 

[joker007]

Thanks Martin works great but now I need to take the number 2 places past the
Decimal here is a example

12.12 would = (12.12) and
-12.12 would equal 12.12

Thanks again

 

[MartinW]

Maybe this,

(#.00);#.00;;

Also take a look here for a full explanation of formatting.
http://support.microsoft.com/default.aspx?id=264372

HTH
Martin

 

[joker007]

Thank you that is just what I needed.

Maybe this,

(#.00);#.00;;

Also take a look here for a full explanation of formatting.
http://support.microsoft.com/default.aspx?id=264372

HTH
Martin

 

[MartinW]

Woops that should be (#.00);#.00;0;

The first one won't show zero values.

HTH
Martin

 

[joker007]

Thanks I caught it and ended up with this.

[Green](#.##);[Red]#.##;;