View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
curranac curranac is offline
external usenet poster
 
Posts: 1
Default Excel changes the year from 2007 to 2003 when a file is copied

When I copy a worksheet in Excel to a new Excel file, the year 2007, such as
1/12/2007 is automatically changed to 1/12/2003. Same goes for 2006, except
that 2/13/2006 becomes 2/13/2002.
Is there a setting I can change inside Excel 2003 to prevent this from
happening?