Darren, Good spotting!
Dave
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Darren Sent: 29 February 2016 21:22 To: profox@leafe.com Subject: RE: Import/Export with CSV
Took a look at that link and it references an Excel add-on - "Power Query" - looks like a great additional to Excel. As a bonus seems to sort out the issue raised.
http://stackoverflow.com/questions/35118402/how-to-correctly-format-an-alpha -numerical-in-an-exported-csv-file-opened-in-exc?rq=1
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Ted Roche Sent: Tuesday, 1 March 2016 2:07 AM To: profoxtech@leafe.com Subject: Re: Import/Export with CSV
On Mon, Feb 29, 2016 at 6:30 AM, Ted Roche tedroche@gmail.com wrote:
Alternatively, there may be some option in the Excel import dialog to turn off "Smart Parsing" or whatever Excel calls it. (LibreOffice user, sorry.)
See Also: http://stackoverflow.com/questions/35118402/how-to-correctly-format-an-alpha -numerical-in-an-exported-csv-file-opened-in-exc?rq=1
-- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com
[excessive quoting removed by server]