Converting imported cell from exponential form

  • Thread starter Thread starter Katie Mac
  • Start date Start date
K

Katie Mac

Hello, I'm having trouble when I import data into Excel.
Any data including numbers and the letter "E" automatically appears in
exponential form.
For Example:
96E03 9.60E+04
96E003 9.60E+04
10E18 1.00E+19
10E018 1.00E+19
Is there a formula that can be applied to the cells and copied to make life
easier?


Thank you
 
When you import the data, tell the Import Wizard that the field is Text.
 
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

Get rid of scientific formatting on excel. 1
Get rid of scientific format on Excel 2003 1
Imported data from excel showing as exponential number in Access 1
how do i import data from a web page into excel 2007? 1
Import data from Access and doesnt recognize numbers in left func. 6
Forcing Excel to Import .CSV data 2
Extracting Data From The Right of a Cell 1
Formula help please 1

Back
Top