Hi,

I have an excelsheet with data that I extract from an online source. I have assigned a VBA code to this sheet in order to write some of these data in a new sheet. Some data are dates which i am taking in a wrong format. For example, I am taking dates in United Kingdom format (dd/mm/yyyy) and some other are shown as number. When I change the format of these numbers to dates I take the United States format (mm/dd/yyyy). I would like to have all the dates in (dd/mm/yyyy) United kingdom format.

Could you please help me with that?
Do you know if this an error that VBA code creates?
Is there any code that i can run to solve this error?

Thank you in advance.

Georgia.