Thread: I am entering date in Excel when I hit enter a formula appears?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben
 
Posts: n/a
Default I am entering date in Excel when I hit enter a formula appears?
ToolsOptionsTransition.

Uncheck the Transition Formula Entry box.

Uncheck the other two boxes while in there. No need for these unless you want
to emulate Lotus.


Gord Dibben MS Excel MVP

On Mon, 24 Apr 2006 11:29:03 -0700, Sun Devil <Sun
wrote:

I have cleared everything is the cell, etc. Nothing has worked.

Please advise.

Reply With QuoteReply With Quote