Custom number format: decimals

[David Hudson]

I want to create a custom number format that eliminates
decimals when the number entered is a round number.
Examples:

-13.5 would show as (13.5)
-10 would show as (10)
1.25 would show as 1.3
3 would show as 3

Is this possible using custom number formats?

 

[Mike]

Try using this format: #,##0.0;[Red](#,##0.0)

Mike

 

[Ron Rosenfeld]

I want to create a custom number format that eliminates
decimals when the number entered is a round number.
Examples:

-13.5 would show as (13.5)
-10 would show as (10)
1.25 would show as 1.3
3 would show as 3

Is this possible using custom number formats?

No it is not.

You would need to use an event-triggered macro that checks the relevant cells,
and the formats them appropriately depending on the contents.


--ron

 

[David Hudson]

Too bad. Thanks.

-----Original Message-----