Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 14 Messages in 5 Topics

gd > >ROHAN > > > > > >Rohan Young May 28 03:42PM +0530 > ^<#13038ee3f2cb2069_digest_top> > >Dear Ashish Ji, > >Please help me out on this, > >THANKS > >ROHAN > > > > > Topic: Time > Is

$$Excel-Macros$$ Dates in Excel

I have a column of various dates that have the incorrect year, for example: 9/1/2011 12/17/2011 10/31/2011 etc, etc... The year should be 2010 not 2011. Is there a quick remedy to correct this problem for several hundred dates? The Month and day are correct - just not the year. Any ideas? --