Convert a numeric string to date, month, year

Closed
pablo - Oct 26, 2009 at 03:20 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 26, 2009 at 09:43 PM
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 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Oct 26, 2009 at 09:43 PM
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