I have Excel 2007 on two PCs and I cannot get the correct date to appear. Type today’s date 160808 and it becomes 23/04/2340. I tink it has something to do with serial dates i.e. days since 1900 but I cannot find how to switch auto input of serial days to date formatting since 1900 off. Does not hapen in 2003.
