Thanks so much for the help. Works perfectly!

"Niek Otten" wrote:

FormatCellsNumberCustom
In the Type box, enter

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


--
Kind regards,

Niek Otten

"BSAT Student" <BSAT wrote in message
...
How would I format a percentage as a decimal without the leading zero. For
example:
0.532 as .532 - no zero

Any help appreciated.