Simple Excel Question

Plundun · 02-10-2005, 07:12 AM

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 · 02-10-2005, 07:14 AM

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

gottimd · 02-10-2005, 07:15 AM

Quote:

Originally Posted by 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?

put a single quote in front of it like:

'0752816144

Plundun · 02-10-2005, 08:32 AM

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.

02-10-2005, 07:14 AM	#2
JimboJ High School JV Join Date: Aug 2003	Easiest way is to highlight that column, then click on Format... Cells... and change it to a text column.

02-10-2005, 08:32 AM	#4
Plundun n00b Join Date: Nov 2003	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.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)