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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CSV->Excel Data Problem 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
Excel CSV Files; Creating Of 3
CSV to Excel 3
CSV file doesn't save "xEy" style number as text formatted data 1
How do I stop Excel 2007 from using scientific notation? 2
how to resolve incompatibility of saving an excel to csv format 1

Back
Top