Dates error format

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.

Hi, thanks for your reply. The short date has already this format dd/mm/yyyy.

When i do it manually i am taking the dd/mm/yyyy format but the problem is still the same. When I run the code some dates are in dd/mm/yyyy format and some others mm/dd/yyyy. This happens when the format of this column is set up as dates. If I choose the general as format for the column with the dates I take dates either with dd/mm/yyyy or as number. I would like to have the same format (dd/mm/yyyy) for all the dates in this column.

I am not sure if the code creates this error or it is an excel error in general.

I changed all the dates to real Date in the sheet1. I have assigned the VBA code to sheet1 which write some of these dates in sheet2. I have also changed the format of column2 (data with dates) to real Date in sheet2 but i am taking either the dd/mm/yyyy or mm/dd/yyyy format in the column2. The most strange thing is that the sheet1 has all the dates with format dd/mm/yyyy.

What i could like is the format in sheet2 column2 will be the same for each date (dd/mm/yyyy). Hope that i explain it clearly.
thanks