Forum Discussion
Unexpected file type behavior when saving in Excel
I am using Excel Pro Plus 2016, in Windows 10. I have been using Excel with files in Excel and csv formats since the 1990s. I am very familiar with file type saving options and Excel's behavior in g...
If possible I'd recommend leaving the original csv untouched and importing it into Excel using Power Query.
Certain date formats and number / text items have often been changed in the past when editing in Excel and then saving as CSV
Certain date formats and number / text items have often been changed in the past when editing in Excel and then saving as CSV
Yes, good point. Data connections ftw.