Convert a numeric string to date, month, year

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

I downloaded a file that contains a numeric string such as >>> 20091020120000[0:GMT]

How do I change this display to read 10/20/2009?

i am using excel 2007 but will use earlier version if needed.

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
suppose the entry is in A1


=(MID(A1,5,2)&"/"&MID(A1,7,2)&"/"&LEFT(A1,4))+0

if necessary format this to a date
11
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month