This also happens with international phone numbers. You can also use the cell format for zip codes - 00000
Want to see what the actual format of a cell is via automation? Fire up Excel, add some value to a cell and apply a format. ox=GETOBJECT(,[excel.application]) ?ox.ActiveCell.Value ?ox.ActiveCell.Text ?ox.ActiveCell.NumberFormat RELEASE ox -- rk -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Michael Madigan Sent: Wednesday, September 20, 2017 8:19 AM To: [email protected] Subject: [NF] Excel Text formatted cells converting to scientific notation when saving as csv I thought I'd pass this tip along. If you have large text fields with numeric values, like insurance policy numbers or UPC Codes, you have to format the cell with custom type ############### or similar, otherwise the CSV file gets scientific notation values, even if the cell is of type text. Hope this saves someone some time. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/mwhpr10mb17744bc26083763a4f84ec9cd2...@mwhpr10mb1774.namprd10.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
