View Single Post
  #2   Report Post  
bj
 
Posts: n/a
Default

check in <tools<options<calculation and see if 1904 date system is checked.

"mdob" wrote:

I have a excel spreadsheet with a column of dates that was ceated in Office XP.

Example: 5-May-05

We recently updated to office 2003 and now whenever I copy this column into
a different spreadsheet all of the dates change and end in 01 now.