| 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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Separating Date and Time
Put the text string in A1.
Place this in B1 =DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2)) Format column B as a date in the format you would like. 20091110120000[0:GMT]. returns 11/10/2009 (or Nov. 10, 2009) HTH "JWorgull" wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Separating Date and Time
Hi,
use =DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2)) and then custom format the cell with m/dd/yyyy "JWorgull" wrote: 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Separating Date and Time
Thanks. This helps me a great deal!
"Huber57" wrote: Put the text string in A1. Place this in B1 =DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2)) Format column B as a date in the format you would like. 20091110120000[0:GMT]. returns 11/10/2009 (or Nov. 10, 2009) HTH "JWorgull" wrote: 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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Separating Date and Time
Thanks. This helps a great deal!
"Eduardo" wrote: Hi, use =DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2)) and then custom format the cell with m/dd/yyyy "JWorgull" wrote: 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. |
| Reply |
| 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 | |||
Linear Mode
