Macro to convert dates to dd/mm/yyyy

[howard]

I have imported data that appears as yyyy/dmm/dd for eg 2017/10/31 in Col L on sheet Sales Data


I would like a macro to convert these to format dd/mm/yyyy for eg 31/10/2017


Your assistance is most appreciated

 

[Drrellik]

can you just change the cell formatting under custom to be dd/mm/yyy or with a macro Selection.NumberFormat = "dd/mm/yyyy"

 

[howard]

I have formatted the column as dd/mm/yyyy , but nothing happens i.e format does not change

See Sample Data

Excel 2012
	J
2	2018/07/08
3	2018/07/08
4	2018/07/08
5	2018/07/08
6	2018/07/08
7	2018/07/11
8	2018/07/11
9	2018/07/11
10	2018/07/11
11	2018/07/11
12	2018/07/11
13	2018/07/11
14	2018/07/11
15	2018/07/11
Demos

 

[Drrellik]

try this

convert your dates to a number and no .00's looking at just the serial number save it and then convert it back to a date using the custom and see if that works.

 

[howard]

Thanks for the reply and your input. I used text to data DMY on the raw data and it works perfectly

 

[Drrellik]

glad it worked. thank for the feedback