Thank you so much - I knew there was a simple answer!

"Dave Peterson" wrote:

Give it a nice custom format???

Select your range
format|cells|number tab
custom
0000000

(as many digits as you want.)

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.

--

Dave Peterson