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 1st Feb 2019 but when it is copied into excel , excel converts it to 02/01/2019 and reads it as 2nd jan 2019
02/02/2019 works fine but then 03/02/2019 becomes 02/03/2019 etc
A real pain as the webscrape of the csv file was the quickest method of downloading the csv file rather than having to go to the website each time .
If I do the process manually it works fine
Be grateful for some help
2 Replies
No RepliesBe the first to reply