Thread: Dates changing
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
E[_2_] E[_2_] is offline
external usenet poster
 
Posts: 40
Default Dates changing

Ie, it changes from 1 Jan 2009 to 2 Jan 2013.

"E" wrote:

I am copying a date from one file to another. The date is 01/01/2009, with
date number 39814. When I copy this to the other file the number is still
39814, but the date appears as 02/01/2013. Please could you explain why the
date has changed when I cannot see a difference, and recommend how I can fix
this.