View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Got my CWC Got my CWC is offline
external usenet poster
 
Posts: 1
Default How to truncate date

I get query data in the mm/dd/yyyy format. The YYYY starts out being every
year imaginable. I need to change long columns of cells so that the /yyyy
reads 2006. How do I do this?

Example (raw data)
01/15/2003
12/25/2005
03/19/1999

desired data
01/15/2006
12/25/2006
03/19/2006