Dates coverted to formulas

[Guest]

I have a spreadsheet that is coverting dates to formulas. For example, if I
enter "1/1/04" and hit enter, it is converted into "=1/1/4", and the result
is 1 divided by 1 divided by 4, or 0.25. Any idea what setting(s) I need to
change to make it behave how I want?

Thanks.

 

[Niek Otten]

Tools>Options, Transition tab, Uncheck Transition formula entry

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
| I have a spreadsheet that is coverting dates to formulas. For example, if I
| enter "1/1/04" and hit enter, it is converted into "=1/1/4", and the result
| is 1 divided by 1 divided by 4, or 0.25. Any idea what setting(s) I need to
| change to make it behave how I want?
|
| Thanks.

 

[T. Valko]

Goto Tools>Options>Transition

Uncheck everything under Sheet options

 

[Guest]

That does it. Thanks.