98E25 changes to 9.8E+26 -Export

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello to all:
I am having a big issue with this change in Excel when I Export data from
any other application. When numbers have a letter E in the middle changes,
example: 98E25 changes to 9.8E+26. I know that I have to format as text
before the data is entered in any cell; however, this is not possible with
Exports since it’s done automatic. When I click export to excel, excel open
automatic, when the data is in the workbook I have to fix it one by one. Can
you please help to figure out any better solution?
Thank you so much.
 
Can you export the data to a text file?

Then you could use File|Open within excel and choose Text for that field (in the
text to columns wizard).
 
In that case, don't export to Excel, but export to a suitably delimited text
file, and use Excel to open the text file with suitable formatting.
 

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

VBA Code to Export Data from Chart 4
Export to Fixed Width File 2
Export excel to ACT 1
Sum Exported data automatically from Access database 9
export data between excel files 1
text to date when exporting from access to excel 3
Date format getting muddled 3
Date Format changing when exporting from another app 1

Back
Top