Forum Discussion
PeterFenton
Jan 28, 2021Copper Contributor
CSV Download from Website into Excel , Excel Keeps converting the dates incorrectly
Hi, I'm download CSV files from the web using some code I found , it all works fine the website opens uploads the csv file and closes it . The problem is the CSV has the date 01/02/2019 ie the ...
Riny_van_Eekelen
Jan 29, 2021Platinum Contributor
PeterFenton You mention "using some code I found". What code? Are you importing via the "Text-to-columns" wizard or Power Query. Both allow you to specify the date format upon import.