Thread: Extract Date (04/05/06) into Text (040506)
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
ward376 ward376 is offline
external usenet poster
  
Posts: 360
Default Extract Date (04/05/06) into Text (040506)
=LEFT((TEXT(A1,"MM/DD/YY")),2)&MID((TEXT(A1,"MM/DD/YY")),4,2)&RIGHT((TEXT(A1,"MM/DD/YY")),2)

Reply With QuoteReply With Quote