A Agil New Member Dec 8, 2011 #1 Hi, I have the data format in dd.mm.yyyy. Please advise me how to convert it to DD/MM/YYYY. Thank you
Hi, I have the data format in dd.mm.yyyy. Please advise me how to convert it to DD/MM/YYYY. Thank you
Hui Excel Ninja Staff member Dec 8, 2011 #2 Agil Use a Custom Number Format Right Click on the cell Format Cells Number Tab Custom type in dd/mm/yyyy Apply
Agil Use a Custom Number Format Right Click on the cell Format Cells Number Tab Custom type in dd/mm/yyyy Apply
SirJB7 Excel Rōnin Dec 11, 2011 #3 Hi, Agil! Additionally to Hui's response, which I join, if you have the data as text and not date (number) format, you may use: a) =DATEVALUE(SUBSTITUTE(A1,".","/")) b) =DATE(RIGHT(A1,4);MID$(A1,4,2);LEFT(A1,2)) Regards.
Hi, Agil! Additionally to Hui's response, which I join, if you have the data as text and not date (number) format, you may use: a) =DATEVALUE(SUBSTITUTE(A1,".","/")) b) =DATE(RIGHT(A1,4);MID$(A1,4,2);LEFT(A1,2)) Regards.
