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

Need () around whole Numbers
 

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

Need () around whole Numbers
 

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" wrote:

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

Need () around whole Numbers
 

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

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

Need () around whole Numbers
 

Thank you that is just what I needed.

"MartinW" wrote:

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

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

Need () around whole Numbers
 

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

The first one won't show zero values.

HTH
Martin


"joker007" wrote in message
...
Thank you that is just what I needed.

"MartinW" wrote:

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

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

Need () around whole Numbers
 

Thanks I caught it and ended up with this.

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

"MartinW" wrote:

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

The first one won't show zero values.

HTH
Martin


"joker007" wrote in message
...
Thank you that is just what I needed.

"MartinW" wrote:

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

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