Data format problem when open CSV using Excel

  • Thread starter Thread starter Alan Choy
  • Start date Start date
A

Alan Choy

I have a CSV file which contains some data such as "5603000E00". When
I used Excel to open the CSV file, this data is presented as "5.6+E06"
as Excel thinks it is an scientific number. If I used format cell
function to change it back to Text, it will present is "5603000".

Is there anyway to have the data present as "5603000E00" instead?
 
Change the .csv extension to .txt and import it using the text wizard. One of the options in the
wizard is to import selected columns as text, which should fix your problem.
 
Back
Top