Forum Discussion
Solved
Saving as a CSV changes some numbers to dates
We have a file with a field for ordering seats. The field has values such as 12-13, 18-19, 22-23. Any value that starts with 12 or lower gets changed to a date. For example, 8-9 gets changed to Au...
One more option is to enable in Options legacy From Text connector
With it import csv as Data->Get Data->Legacy Wizards->From Text (Legacy), take comma as separator, on the third step of the wizard select all columns and assign Text column data format.
finally uncheck adding data to data model and select destination cell
Preceding each term of the source data by an apostrophe " ' " should force the data to text, but so should pre-formatting the cells as text (once the data is read, it is too late). Importing via Power Query can also improve the chance of success because I think Excel respects text formatting from PQ.