I have been working on a spreadsheet for a couple of months now and in
the past two day I have begun having a problem when entering the date
in to a cell.

Everything was working fine

I would enter the date as (lets say) 8/22 and it would format it for
me to 8/22/07

Now however it is doing something like this (I enter) 8/22 and it
formats it as 8/1/22

I am sure that it is a preferance somewhere that I am missing and It
is driving me crazy.

I have not changed any of the cell formating and all of the old dated
that I have entered still look fine.

any help would be appreciated

Thank you,
Philip