View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kevin
 
Posts: n/a
Default change year date

I have data that has dates of 4/25/200, 4/25/20,4/25/2020

How do I change the year to show 2006 without changing the month or day