Cells converting ###s to formulas
 

I am using a spreadsheet that someone in our London office created. Whenever
we input a number in a cell, it will automatically put it in as a formula
[with an =]. So if I try to put 12/12/06, the cell will read .1666667.

How can I turn this off?

Thanks.

Marco

Cells converting ###s to formulas
 

Tools|Options|Transition tab
Turn off those old Lotus 123 settings.

Marco wrote:

I am using a spreadsheet that someone in our London office created. Whenever
we input a number in a cell, it will automatically put it in as a formula
[with an =]. So if I try to put 12/12/06, the cell will read .1666667.

How can I turn this off?

Thanks.

Marco

--

Dave Peterson

Cells converting ###s to formulas
 

Thanks. I knew it would be something simple like that. :-)

"Dave Peterson" wrote:

Tools|Options|Transition tab
Turn off those old Lotus 123 settings.

Marco wrote:

I am using a spreadsheet that someone in our London office created. Whenever
we input a number in a cell, it will automatically put it in as a formula
[with an =]. So if I try to put 12/12/06, the cell will read .1666667.

How can I turn this off?

Thanks.

Marco

--

Dave Peterson