Custom number format: decimals

  • Thread starter Thread starter David Hudson
  • Start date Start date
D

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?
 
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?
Click to expand...

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
 
Back
Top