How do I turn off the auto formatting to scientific notation in Excel? Our users are receiving email attachments from a vendor’s mainframe in .csv format. The csv file has quotations around all text fields but this doesn’t help. When the users try to open the file, it automatically formats some of the data as scientific notation. The data being corrupted is either a FedEx tracking # like “006854230175290” or a vendor’s part number that has an E in it like “0636107208E001". Has anyone found an option in Excel or registry key that disables auto formatting to scientific notation when opening a csv file?