ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Stop Excel Removing Zero at beginning of number (https://www.excelbanter.com/excel-discussion-misc-queries/131247-stop-excel-removing-zero-beginning-number.html)

bird007

Stop Excel Removing Zero at beginning of number
 
Hi can anybody shed some light on how i do this

Thanks

D.

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