Converting dates in the appropriate format

[Nelson78]

Hello everybody.

In importing data from an external agent, I have to deal with the following situation:

https://imgur.com/a/oU9GE8j

I have to use, preferably, the format dd/mm/yyyy.

But the dates in the yellow cells are not correct, and they are not handleable in a usual way.
I mean: they are respectively 3rd October 2017, 6th Novembre 2015 and 1st July 2015, but Excel "reads" 10th March 2017, 11th June 2015 and 7th January 2015. I realize this in performing differences beetween dates (for instance today - date).

I need a vba solution to adjust all the values.

Thank you in advance.

 

[jbenfleming]

You could loop through the cell group and run something like:

Range("a1").Value = VBA.Format(Range("a1").Value, "dd/mm/yyyy")

 

[Nelson78]

You could loop through the cell group and run something like:

Range("a1").Value = VBA.Format(Range("a1").Value, "dd/mm/yyyy")

Yes: the tests I've performed so far are all positive.

Thank's a lot.