I have typed in a date 12/01/07 and it displays correctly until I move from
the cell the it changes to 1/12/07 or something like 37896. Nothing I try
seeems to fix this. I have tried changing the date format, it is currently
set to show as 12/01/07. I have tried deleting the cell and starting again. I
have tried removing the whole column and starting again.I dont know what has
happened but since I tried typing it in another empty cell it showed as a
wierd number in the empty cell so I just deleted that and tried again in the
correct cell and now all I get is the date changing to 1/12/07. Also as soon
as I type a date in this cell it makes my formula appear with an error! I am
using Excel version 2007. THis is driving me crazy, can anyone help?