View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default 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