How do I convert GMT data from a CSV file to dates?
R Rodrigo Ferreira Apr 11, 2007 #4 Something like this: =DATE(LEFT(C2;4);MID(C2;5;2);MID(C2;7;2)) + TIME(MID(C2;9;2);MID(C2;11;2);MID(C2;13;2)) -- Rodrigo Ferreira Ron said: Example of my data is: 20070302120000[0:GMT] Ron said: How do I convert GMT data from a CSV file to dates? Click to expand... Click to expand...
Something like this: =DATE(LEFT(C2;4);MID(C2;5;2);MID(C2;7;2)) + TIME(MID(C2;9;2);MID(C2;11;2);MID(C2;13;2)) -- Rodrigo Ferreira Ron said: Example of my data is: 20070302120000[0:GMT] Ron said: How do I convert GMT data from a CSV file to dates? Click to expand... Click to expand...
