Format percentage as a decimal

[BSAT Student]

How would I format a percentage as a decimal without the leading zero. For
example:
0.532 as .532 - no zero

Any help appreciated.

[Niek Otten]

Format>Cells>Number>Custom
In the Type box, enter

..###############


--
Kind regards,

Niek Otten

"BSAT Student" <BSAT [email protected]> wrote in message
news:[email protected]...
> How would I format a percentage as a decimal without the leading zero. For
> example:
> 0.532 as .532 - no zero
>
> Any help appreciated.

[BSAT Student]

Thanks so much for the help. Works perfectly!

"Niek Otten" wrote:

> Format>Cells>Number>Custom
> In the Type box, enter
>
> ..###############
>
>
> --
> Kind regards,
>
> Niek Otten
>
> "BSAT Student" <BSAT [email protected]> wrote in message
> news:[email protected]...
> > How would I format a percentage as a decimal without the leading zero. For
> > example:
> > 0.532 as .532 - no zero
> >
> > Any help appreciated.
>
>
>