Excel swap day with month when Write Range

[mz3bel (Mohssine HILAL)]

@AS_Deloen

Hi, this will fix ur issue

Get a date in formart "dd/mm/yyyy"

@Bruno_Luan_Carvalho It sounds like you said that on the website the dates are in “dd/mm/yyyy” format? I think you need to treat it normally as a string and just write it in that format to Excel. You can change the default date format that your computer sees by going to Control Panel > Region and Language. Changing that setting will see the day and month in the correct spot. However, if you don’t want to change your region and use the basic mm/dd format so you want to convert it then you woul…