ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   support for leading zeros in excel (https://www.excelbanter.com/excel-discussion-misc-queries/62444-support-leading-zeros-excel.html)

Vincenzo

support for leading zeros in excel
 
I need to put leading zero's in excel cells. Can somebody please help.

Thanks,
Vincenzo

Dave Peterson

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