Assuming the original date is in A1, put this in B1 and copy down:
=MID(A1,9,2)&"."&MID(A1,6,2)&"."&LEFT(A1,4)
Assuming the original date is in A1, put this in B1 and copy down:
=MID(A1,9,2)&"."&MID(A1,6,2)&"."&LEFT(A1,4)
SPARTAN
Please click the * if my solution helped
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks