View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
joker007 joker007 is offline
external usenet poster
 
Posts: 6
Default Need () around whole Numbers

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