Zero at the beginning of a number

[Guest]

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]

Give it a nice custom format???

Select your range
format|cells|number tab
custom
0000000

(as many digits as you want.)

 

[Guest]

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

 

[Guest]

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

 

[Guest]

If you format the cell, in the number tab, select "Text". This then allows
you to enter a number starting with a "0". It also lets you write a number
without a "0". It basically lets you rnter into a cell literally what you
type.