Help!

Excel mistakenly formats as Scientific Notation
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Data Map RSS
Next:  Macro query  
Author Message
JBme



Joined: Aug 31, 2007
Posts: 1
PostPosted: Fri Aug 31, 2007 4:00 pm    Post subject: Excel mistakenly formats as Scientific Notation
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?
Thanks
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Data Map All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum