View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andibevan
 
Posts: n/a
Default Problem with dates

Hi There,

On my laptop when I enter a date in a cell (I am in UK so I have format day
/ month / year) as 1/12 it automatically changes it to 1/12/2005. But when
I do the same on my desktop it changes it to 1/12/2006 - is there a setting
that effects this as I can't see why it reacts differently.

Ta

Andi