Automatic = sign insertion

[spreadsheet_johnny]

I am a newbie to the board and have had several lingering questions anwered already today by scouring the board. I have a problem that I can't seem to figure out.
I formatted a cell for date, and after I type 09/14/02, the output in the cell is 01/00/00. When I go back to the cell, the contents have been changed to =9/14/2. Is there a setting somewhere to turn this "feature" off? Please help!!

 

[Mark W.]

Choose the Tools | Options... menu command's "Transition" tab and uncheck the "Transition formula entry" option.

 

[spreadsheet_johnny]

Thanks for the quick response Mark.

It solved the problem!