lost case number

[mattweber]

I am working on a project for the local police department.  When I open the excel file in arcgis9.3 all the information is correct.  However after the data has been geocoded the police identification number is not there.  The only part of the number that remains is the year, however the unique identification numbers have all turned to zeros.  I have tried to reformat the cell in arcgis to various number configurations under properties without success.  Any suggestions would be greatly appreciated.
matt
wittenberg university

[JoeBorgione]

I am working on a project for the local police department.  When I open the excel file in arcgis9.3 all the information is correct.  However after the data has been geocoded the police identification number is not there.  The only part of the number that remains is the year, however the unique identification numbers have all turned to zeros.  I have tried to reformat the cell in arcgis to various number configurations under properties without success.  Any suggestions would be greatly appreciated.
matt
wittenberg university

Do youself a favor and import your spread sheet into a table in some flavour of geodatabase and geocode that. Excel is for accountants. Database tables are for analysts. Let the flames begin.

[AnnaRoberts]

Have you tried changing the cell type in Excel, before importing it? Or saving your Excel file as a .csv and importing that instead?

[mattweber]

yes tried that ended up having to go back and reformat excel sheet and create new attribute header.  thankyou for the help