Thread: Date conversion
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
programmernovice[_2_] programmernovice[_2_] is offline
external usenet poster
  
Posts: 61
Default Date conversion

try:
=RIGHT(YEAR(A1),2)&TEXT(MONTH(A1),"00")& TEXT(DAY(A1),"00")



Perfect! Many thanks for your help, Klaus. If memory serves, you've always been helpful to me and I appreciate it.
Reply With QuoteReply With Quote