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.

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.

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.

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.

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.