Thread: How do you convert an uncoded date (e.g., 20080304) to a date form
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default 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
Reply With QuoteReply With Quote