Custome Number format based on Value
 

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?
--
Dr. Sachin Wagh
MBBS, DHA, DPH

Custome Number format based on Value
 

[<10]0.0;0

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Dr. Sachin Wagh" wrote in message
...
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?
--
Dr. Sachin Wagh
MBBS, DHA, DPH

Custome Number format based on Value
 

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


"Bob Phillips" wrote:

[<10]0.0;0

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Dr. Sachin Wagh" wrote in message
...
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?
--
Dr. Sachin Wagh
MBBS, DHA, DPH