How to change the date format mm/dd/yy to mm/dd/yyyy format

[mz3bel (Mohssine HILAL)]

Hi @Boopathi

Check this below might help

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…