How to enter a number beginning with 0

Originally Posted by daddylonglegs

You can either format as text before you enter......or use a custom number format like 0000 (assuming you always have 4 digits)

......or add a preceding apostophe like

'0925

that tells excel to treat the entry as text (it won't display the apostrophe)

daddylonglegs, excellent as usual.

Both the text format and the apostrophe work.

Thanks

Si