Forum Discussion
Disable auto formatting in Excel
Problem I'm having issues with dates and numbers in particular where an integer number may be converted to scientific notation (non destructive), although not always, and dates are converted to numb...
Import your CSV with Power Query, set the correct data types and you are done.
Thanks, that does kind of solve the problem it's just seemingly substantially more effort that I believe is necessary. Point taken though that this function may be too edge case for the average consumer. It would seem other people ask about it, but as for the percentage of users that do, I'm not sure.
