View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cathy Cathy is offline
external usenet poster
 
Posts: 104
Default Pasting dates from one spreadsheet to another

Hi there

I have inherited an excel database which includes columns with dates. When
I copy the columns and paste them into another file, the dates do not copy
properly -

For example:
07/07/1984 becomes 06/07/1980 and 02/07/07 becomes 01/07/03

I have tried going into paste special and pasting "values" only but this
does not work. Does anyone know why this happens and how to solve the
problem?

thanks a million

Cathy