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

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

[Dave Peterson]

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



JPaterson wrote:
>
> 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.
>
> --
> JPaterson
> ------------------------------------------------------------------------
> JPaterson's Profile: http://www.excelforum.com/member.php...o&userid=33967
> View this thread: http://www.excelforum.com/showthread...hreadid=543909

--

Dave Peterson

[JPaterson]

Thanks very much.