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

Hi

Assuming the dates are in column A, in another column enter
=DATE(2006,MONTH(A1),DAY(A1))
and copy down.

To "fix" the values, copy the column of data then Paste SpecialValues.
--
Regards

Roger Govier


"Got my CWC" <Got my CWC @discussions.microsoft.com wrote in message
...
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

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