Custome Number format based on Value

D

Dr. Sachin Wagh

Hi!

It makes relevance for me in case I have a single decimal of a figure less
than 10 (ex: 9.2, 2.1), but no decimal if the value is 10 or above

Is there a way to do this customization through format

Any takers?
 
B

Bob Phillips

[<10]0.0;0

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
D

Dr. Sachin Wagh

Thanx a ton Bob; life's more comfortable now!
--
Dr. Sachin Wagh
MBBS, DHA, DPH


Bob Phillips said:
[<10]0.0;0

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
Click to expand...
 
Top