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.
|