Front Office Football Central - Simple Excel Question

Front Office Football Central (https://forums.operationsports.com/fofc//index.php)

- FOFC Archive (https://forums.operationsports.com/fofc//forumdisplay.php?f=27)

- - Simple Excel Question (https://forums.operationsports.com/fofc//showthread.php?t=35818)

Plundun

02-10-2005 07:12 AM

Simple Excel Question

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

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.

All times are GMT -5. The time now is 12:10 PM.