Importing CSV files

  • Thread starter Thread starter kapsgp
  • Start date Start date
K

kapsgp

When importing a CSV file into Excel, a number such as
,"1-3012", becomes Jan-01 in the cell. If I then format the cell a
text, the date turns into a number (serial number) representation o
the date and has no relation to the original number. I have not foun
a way to turn off this feature that auto-formats a quoted number strin
into a date. I can add an apostrophy before the number but then i
appears in the Excel worksheet unlike putting it directly into the cel
with the keyboard. Any ideas?

Thanks
 
There are a couple of ways, you can rename the csv file to txt instead and
excel will automatically
launch the text import wizard and in step 3 you can select the column in
question and check Text under column data format. Or you can do data>import
external data>import data,change the file name to *.*, find your csv file
and open it,
that will also launch the text import wizard..
 
Back
Top