EXCEL zero

[748rhydhir]

how do you write a number in rows or columns with the initial number 0.eg 01234.
It will write the 0 but when you move on the 0 goes & you are left with 1234.

many thanks
regards,
john

[ChuckFickens]

click the cell you want to change click on the format menu and select celll and then scroll down the list and change it to a text cell.

Then any number will keep the leading 0

[kempie]

Alternatively type a ' (single quote) before the number

e.g '012345

[748rhydhir]

many thanks for swift replies.
chuckfickens solution worked a treat.