![]() |
Format percentage as a decimal
How would I format a percentage as a decimal without the leading zero. For
example: 0.532 as .532 - no zero Any help appreciated. |
Format percentage as a decimal
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. |
Format percentage as a decimal
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. |
All times are GMT +1. The time now is 11:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com