I was asked the other day about changing the date format in Excel from ddmmyyyy to dd/mm/yyyy. I tried using custom formatting without success.
Assuming that the first date to be converted is in cell A2, I used the following formula =LEFT(A2,2)&”/”&MID(A2,3,2)&”/”&RIGHT(A2,4) and that did the trick.
If any dates begin with 0, you may need to convert then to text first as they will not show the initial 0 if they are in number format.
Find further details about our Excel training courses Sydney.