![]() |
Stop Excel Removing Zero at beginning of number
Hi can anybody shed some light on how i do this
Thanks |
Stop Excel Removing Zero at beginning of number
Hi,
Probably formatting the cells select a cell you want formatted, right click on mouse, format cells,custom, enter the custom format, like 0000 or something that will suite you Another idea, would be to format the cell as text then you could enter 0123 or you couls use an ' '0123 |
All times are GMT +1. The time now is 06:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com