View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stuart Perry Stuart Perry is offline
external usenet poster
 
Posts: 2
Default Problem with dates

Hi there
I'm using Excel 2002 with SP3 installed
I'm having a few problems with dates. I've formatted the cell to use a date
format of 14.03.01 but when I enter the date (by typing for example 010108)
instead of changing the data to 01.01.08 it changes it to 3.9.27.

Any ideas what I'm doing wrong, am I simply entering the data wrong?.