R
RiTz21
I need a special number format, but I can't seem to get what I want:
IF a number is an integer, then there should be NO decimal point
displayed.
IF a number has a decimal part, then if should display only one digit
for it.
For instance:
3 -> 3
4.34 -> 4.3
2.88 -> 2.9
34 -> 34
5.01 -> 5.0
Is it possible to do this with a custom number format ?
THANKS !
R
P.S. I would prefer NOT to use any VBA to do this!
IF a number is an integer, then there should be NO decimal point
displayed.
IF a number has a decimal part, then if should display only one digit
for it.
For instance:
3 -> 3
4.34 -> 4.3
2.88 -> 2.9
34 -> 34
5.01 -> 5.0
Is it possible to do this with a custom number format ?
THANKS !
R
P.S. I would prefer NOT to use any VBA to do this!