3 ms·
That can be turned off (easily Googled), or as mentioned, doesn’t affect proper import using Power Query. Also, if you control the data format and know Excel is
by NetMageSCW 1y ago
That can be turned off (easily Googled), or as mentioned, doesn’t affect proper import using Power Query. Also, if you control the data format and know Excel is the intended target, you can just output your CSV so Excel won’t do that (put =“ and “ around text columns).
For any spreadsheet which are updated by refreshing source data such as CSV output from other systems, PowerQuery is what should be used and is very effective.
- epistasis 1y agoWhat are the web search terms you use to find to turn this off? Most people have not been able to figure this out, with the help of the web or in the application itself. The typical windows user is not going to be accomplish a successful import, except maybe by whatever the heck PowerQuery is.