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 of the columns had dates in it. When he copied the dates from the source spreadsheet to the target spreadsheet - all the dates changed by a time factor of 4 years and 1 day! I asked him to send me the spreadsheet and when I followed his steps - and copied several dates from the source spreadsheet to a new spreadsheet that I had created - the exact same thing happened - the dates all moved 4 years and 1 day earlier. I would sure appreciate your help explaining this if you can. The dates are entered as values and there are no funky formats being used. Thanks. Regards, Allen
-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
