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" escreveu na mensagem
...
Example of my data is: 20070302120000[0:GMT]


"Ron" wrote:

How do I convert GMT data from a CSV file to dates?