4 Replies Latest reply on Aug 4, 2015 7:09 AM by jlloyd

    Excel import - text being read as exponential value by Excel

    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!