Thanks so much. I was on the right track - just didn't go far enough down it!

"Zeros at the front of numbers" wrote:

How can I get a number eg. 0123456 to keep the zero showing in the cell,
without using the apostrophe? I need to be able to sort the numbers
eventually. Thanks.