Format percentage as a decimal

BSAT Student · Oct 20, 2005

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 · Oct 20, 2005

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

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

BSAT Student · Oct 20, 2005

Thanks so much for the help. Works perfectly!

Niek Otten said:
Format>Cells>Number>Custom
In the Type box, enter

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