Hi, on my old computer with excel 2003, I can enter aug7 into a cell and it will be automatically changed to 7-Aug, with the display in the input field up top reading 8/7/2009. (it always assumes the current year)
On my new computer, with Excel 2007, when I enter aug7, it changes to Aug-07, and the display in the input field up top says 01/08/2007.
So it assumes I have told it the year instead of the day.
How can I make 2007 behave like 2003?
Thanks lots!
On my new computer, with Excel 2007, when I enter aug7, it changes to Aug-07, and the display in the input field up top says 01/08/2007.
So it assumes I have told it the year instead of the day.
How can I make 2007 behave like 2003?
Thanks lots!