How do you convert an uncoded date (e.g., 20080304) to a date form
 

After importing credit card info from my bank, all I see is
"20080320120000[0:GMT]". I want that to read 03/20/08. How in the world can
I do that efficiently? Please help!

Thank you,
Eric

How do you convert an uncoded date (e.g., 20080304) to a date form
 

=DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2))
--
Gary''s Student - gsnu200780

How do you convert an uncoded date (e.g., 20080304) to a date form
 

=--TEXT(LEFT(A1,8),"0000\/00\/00")

format cell as mm/dd/yy


"tenorofchange" wrote:

After importing credit card info from my bank, all I see is
"20080320120000[0:GMT]". I want that to read 03/20/08. How in the world can
I do that efficiently? Please help!

Thank you,
Eric

How do you convert an uncoded date (e.g., 20080304) to a date form
 

"tenorofchange" wrote:

After importing credit card info from my bank, all I see is
"20080320120000[0:GMT]". I want that to read 03/20/08. How in the world can
I do that efficiently? Please help!

Thank you,
Eric

=--TEXT(LEFT(A1,8),"0000\/00\/00")

Regards
Bosco

How do you convert an uncoded date (e.g., 20080304) to a date
 

=--TEXT(LEFT(A422,8),"00-00-00")

Bosco_yip


"bosco_yip" wrote:



"tenorofchange" wrote:

After importing credit card info from my bank, all I see is
"20080320120000[0:GMT]". I want that to read 03/20/08. How in the world can
I do that efficiently? Please help!

Thank you,
Eric

=--TEXT(LEFT(A1,8),"0000\/00\/00")

Regards
Bosco

How do you convert an uncoded date (e.g., 20080304) to a date form
 

=--TEXT(LEFT(A422,8),"00-00-00")

Regards
Bosco


"tenorofchange" wrote:

After importing credit card info from my bank, all I see is
"20080320120000[0:GMT]". I want that to read 03/20/08. How in the world can
I do that efficiently? Please help!

Thank you,
Eric