I have a spreadsheet with a date field - I need to copy parts of the sheet to another worksheet. When I copy the dates they are inexplicably changed - Formatting has been meticulously checked. The most common change is that the month remains the same, the date is one day less than the original, and year is four years earlier. So 01/18/06 becomes 01/17/02 - happens in every date format. Over and over. Also, in the pick from list option for cell, there is a choice 2- 14. I don't know what this means or why it's there. Does it have something to do with my problem?(Moderator edit: post moved to more appropriate forum. jgweed)
Edited by jgweed, 02 June 2006 - 07:55 AM.