Hi can anybody shed some light on how i do this

Thanks

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