I'm using Excel 2002. When I type a date, it changes the cell to the
formula and it changes what I typed to something else.

Example:

I type "8/25/2006" without the quotes. I hit enter and it changes to
"=8/25/2006" in the forumla bar. But the cell displays "1/0/1900".

I'm sure there is a setting causing this. Can someone help me?

Thanks,
Paul