How to truncate date
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
|