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.

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

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

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.

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.

"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.