Forum Discussion
Excel .csv Conversion - Date-Formatting keeps returning even with prior formatting
PeterBartholomew1No never tried Power Query, but I also don't think it's possible. We have a scanning system in place which delivers all data already in excel-files. So there's only importing from one type of excel-file to a .csv. We don't have a text-file of raw data which is then exported to .xlxs.
Opening csv file Excel performs all operation as with excel file, that's how the parser works. For example, if you have comma delimited file with one text string
1,2,=a1+b1
an open it in Excel, result in a1, b1 and c1 will be
1 2 3
and working formula in C1.
To prevent default converting of texts to numbers and dates perhaps the easiest way is to add the space at the front of text which could be converted, or two single apostrophes, but it's more visible.
If such data
save as csv and open it in Excel, we will have
i.e. only A2 is converted.
Otherwise Get Data from Text File using legacy connector and applying Text format to all columns on the third step of the wizard.