How do I convert GMT data to dates?
 

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

How do I convert GMT data to dates?
 

what does the gmt data look like?

"Ron" wrote:

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

How do I convert GMT data to dates?
 

Example of my data is: 20070302120000[0:GMT]


"Ron" wrote:

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

How do I convert GMT data to dates?
 

How do I convert GMT data from a CSV file to dates?
Example of my data is: 20070302120000[0:GMT]


After opening the file in Excel, one way is:
=DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2))

How do I convert GMT data to dates?
 

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?