Re: $$Excel-Macros$$ Copying Dates - STRANGE behavior

2010-01-13 Thread kvc praveen kumar
Thanks Dilip!!! :-) On Wed, Jan 13, 2010 at 5:08 PM, Dilip Pandey wrote: > Good One..!! :) > > > Best Regards, > -- > DILIP KUMAR PANDEY > MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 110062 > > > On Wed, Jan 13, 2010 at 11:44 A

Re: $$Excel-Macros$$ Copying Dates - STRANGE behavior

2010-01-13 Thread Dilip Pandey
Good One..!! :) Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Jan 13, 2010 at 11:44 AM, kvc praveen kumar wrote: > Hello Allen, > > I guess the excel from which you are getting thadates

Re: $$Excel-Macros$$ Copying Dates - STRANGE behavior

2010-01-12 Thread kvc praveen kumar
Hello Allen, I guess the excel from which you are getting thadates from is in 1904 date system. and yours is in 1900 date system. All you need to do is to uncheck the "use 1904 data system" in your source excel - excel options. This is my first thought. let me know if it helps. On Wed, Jan 13, 2

$$Excel-Macros$$ Copying Dates - STRANGE behavior

2010-01-12 Thread Allen Miller
Here's a good one. I was a spreadsheet jockey a long time ago. I am an IT Consultant now - mostly doing server & network management. This one has me puzzled. A client contacted me and said he got a (2007) spreadsheet somewhere and just wanted to copy 2 columns from it to a new spreadsheet. One