| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert GMT data to dates?
How do I convert GMT data from a CSV file to dates?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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)) |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert dates in Excel? | Excel Discussion (Misc queries) | |||
| Convert dates | Excel Worksheet Functions | |||
| How to convert data in General Format cells to dates | Excel Discussion (Misc queries) | |||
| Convert Dates | Excel Worksheet Functions | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Hybrid Mode
