![]() |
support for leading zeros in excel
I need to put leading zero's in excel cells. Can somebody please help.
Thanks, Vincenzo |
support for leading zeros in excel
Preformat the cell(s) as Text
Precede your data entry with an apostrophe: '000123 Or give the cell(s) a custom format of: 00000 (via format|cells|number tab|custom category--use as many zeros as you need) Vincenzo wrote: I need to put leading zero's in excel cells. Can somebody please help. Thanks, Vincenzo -- Dave Peterson |
All times are GMT +1. The time now is 03:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com