Thread: How do you convert an uncoded date (e.g., 20080304) to a date form
View Single Post
  #6   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
=--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
Reply With QuoteReply With Quote