Hello, How can I convert the date with the format YYYYMMDD to MM/DD/YYYY with a formula? Thanks,
J JIM.H. Oct 26, 2005 #1 Hello, How can I convert the date with the format YYYYMMDD to MM/DD/YYYY with a formula? Thanks,
A Arvi Laanemets Oct 26, 2005 #2 Hi With date in A1 =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)) and format in any valid date format
R Roger Govier Oct 26, 2005 #3 Hi Jim Try =MID(A1,5,2)&"/"&LEFT(A1,4)&"/"&RIGHT(A1,2) Regards Roger Govier
G Gary76 Oct 26, 2005 #4 Assuming the date is numeric, something like: =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)) HTH
