Forum Discussion
Solved
Ensure Excel retains field value as text string, rather than converting to number
Hey all, Prob a stupid question. But is there a way to prevent Excel from converting a text string value in a CSV field, to a number? I have a valid string value in a field "000000000", but a...
glennlee You can connect to the CSV with Power Query and set-up the transformations once. Like indicating that this particular column should be seen as text. Next time when the CSV gets updated, refresh the query and the import will run automatically as is was set up the first time.
You could wait for the "control data conversions" feature which is still in Beta/Insider.
https://insider.office.com/en-us/blog/control-data-conversions-in-excel