Jan 28 2021 10:41 AM
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
Jan 28 2021 12:31 PM
Jan 29 2021 11:09 AM
@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.