View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Marco Marco is offline
external usenet poster
 
Posts: 69
Default 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