Only single date then Will swap
8/1/2018 8 Jan -after scrap- 1/8/2018 1 aug
As long there is a double digit day or month it won’t change
17/10/2018 17 oct -after scrap- 17/10/2018 17 oct
8/10/2018 8 oct - after scrap- 8/10/2018 8 oct
17/8/2018 17 aug - after scrap- 17/8/2018 17 aug
What are you using to scrape the data?
Also , where are you scraping it from?
using data scraping from website that is confidential
You want it to get swapped or it’s getting swap and you don’t want it ??
DATE ARE INCORRECT WHEN USING DATA SCRAPING FROM SITE TO EXCEL. I DID NOT FORMAT ANY DATES…
Could you try how it saves using two different write range activities, mainly these two:
It should work with the workbook one.