Simple Excel Question

[Plundun]

I need to input some ISBN values in Excel. Problem is that some ISBN values contain a 0 as the first number (0752816144) and Excel automatically removes them (752816144). I have looked at the AutoCorrect features but it is not listed there. How can I get Excel to include the zero?

[JimboJ]

Easiest way is to highlight that column, then click on Format... Cells... and change it to a text column.

[gottimd]

I need to input some ISBN values in Excel. Problem is that some ISBN values contain a 0 as the first number (0752816144) and Excel automatically removes them (752816144). I have looked at the AutoCorrect features but it is not listed there. How can I get Excel to include the zero?

put a single quote in front of it like:

'0752816144

[Plundun]

Thanks both, I had tried to use " in front of the ISBN-number as that was how it was in the Works Database I used to use.