Numbers change to Date error

L

Lakewoodsale

I have downloaded a CSV file with 55000 rows of data in it, into an excel
worksheet. Before importing, the sheet is formated as TEXT, for all columns.
It has 3 columns in it: Price, Description, Replacement Number. I get back
errors on some of the numbers. A number like 10-8040 or 5-7280 will show up
as OCT-40 or MAY-30. After setting up the file I see a mark in the upper
left corner of numerous boxes. I select the mark and I am asked if I wish to
ignore the error. Then I select the entire sheet and select to ignore the
error. Still I get back these . Help is appreciated. Thank you.
 
D

Dave Peterson

You could rename the *.csv file to *.txt. Then if you use File|Open to open
that .txt file, you'll be prompted for how each field should be treated.

You could avoid the renaming if you use:
Data|import external data|Import data
(xl2003 menus)
 
Top