| Home |
| Search |
| Today's Posts |
|
#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? |
| 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 | |||
Threaded Mode
