Thread: how can I change MMDDYY to YYYYMMDD?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mhayes mhayes is offline
external usenet poster
  
Posts: 1
Default how can I change MMDDYY to YYYYMMDD?
The formula =MID(C7,5,2) & LEFT(C7,2) & MID(C7,3,2) gets me to YYMMDD. I
can't figure out how to get the year in full (YYYY).
Reply With QuoteReply With Quote