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

[<10]0.0;0

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Dr. Sachin Wagh" <DrSachinWagh@discussions.microsoft.com> wrote in message
news:FD06F077-88EE-4E1A-B71E-1A4B2F72175A@microsoft.com...
> 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

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" <DrSachinWagh@discussions.microsoft.com> wrote in message
> news:FD06F077-88EE-4E1A-B71E-1A4B2F72175A@microsoft.com...
> > 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
>
>
>