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
|