Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Separating Date and Time
I am working with data received from my financial institution. The date and
time field returns the following data: 20091110120000[0:GMT]. The time is not important, but I am looking to separate the date into a mm/dd/yyyy format. Thanks for any help you can provide. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Separating date from a Date & Time stamp | Excel Discussion (Misc queries) | |||
Figuring time worked, and then separating it into regular time an. | Excel Worksheet Functions | |||
Separating invoices by invoice date then summing by quarter | Excel Worksheet Functions | |||
Separating day time segments | Excel Discussion (Misc queries) | |||
Separating data ( 1 time range) in one column | Excel Worksheet Functions |