Stupid question, but how do I add a zero in front of numbers?

  • Thread starter Thread starter JPaterson
  • Start date Start date
J

JPaterson

I'm working on my book collection listing, and one column I have is for
the ISBN number. Most books have a zero in front of the number, like:

0451526775

However, when I input that, the zero is removed. How do I make it so
the zero stays? Preferably, I want it to be limited to this one
column, not the worksheet, workbook, or Excel in general. I'm assuming
I can highlight the column, right click, choose "Format Cells", and dink
around under "Numbers", but what do I change exactly?

Thanks.
 
If you always want 10 digits, you can use:

Format|cells|Number tab|custom
0000000000

A couple of alternatives:
Prefix your entry with an apostrophe:
'0451526775
or
Preformat the cells as Text
format|cells|number tab
Text
 
Back
Top