ExcelBanter - Converting imported cell from exponential form

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Converting imported cell from exponential form (https://www.excelbanter.com/excel-worksheet-functions/178089-converting-imported-cell-exponential-form.html)

Katie Mac

Converting imported cell from exponential form

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

Gary''s Student

Converting imported cell from exponential form

When you import the data, tell the Import Wizard that the field is Text.
--
Gary''s Student - gsnu200770

"Katie Mac" wrote:

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

All times are GMT +1. The time now is 10:09 AM.