Thread: How do you convert an uncoded date (e.g., 20080304) to a date form
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bosco_yip[_2_] bosco_yip[_2_] is offline
external usenet poster
  
Posts: 24
Default 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

Reply With QuoteReply With Quote