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
|