Hi,

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

HTH
Martin


"joker007" wrote in message
...
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