AnsweredAssumed Answered

Excel import - text being read as exponential value by Excel

Question asked by jlloyd on Aug 4, 2015
Latest reply on Aug 4, 2015 by jlloyd

We import an excel file (.xlsx) into our database as a monthly update.  One of the fields in the Excel spreadsheet is a code, which includes the values "1E1" and "1E2".  No matter how I format them in Excel, when I import, Excel treats them as exponential values.  After the import, I have to replace all the 100s with 1E2 and all of the 10s with 1E1.  I was wondering if there is something I can do in Excel to keep that from happening or should I just put something in the script that imports the spreadsheet?  I know it's an Excel problem because we didn't have this problem before we upgraded to Microsoft Office 2010.

 

Also, I just marked this 'Assumed Answered' by accident and can't figure out how to put it back.  It's not answered.  Sorry and thanks for any help anyone can provide!

Outcomes