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!