I used =text(A1,mm/dd) &"/2006". To convert it to a value, copy, paste
special and choose 'values'.

"Got my CWC" wrote:

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