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
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
THANK YOU! The legacy import worked like a charm. You have my undying gratitude