Posted to microsoft.public.excel.newusers

Gord Dibben

Posts: n/a

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how do i set up a date stamp formula in excel?	mgawbamo	Excel Worksheet Functions	2	July 28th 05 04:52 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM
How do I enter a date before 1900 in excel?	woodrat	Excel Worksheet Functions	3	January 14th 05 02:39 PM
How do I enter a date before 1900 in excel?	woodrat	Excel Worksheet Functions	1	January 14th 05 10:37 AM
I am entering data but it appears as a date in excel	BHellings	Excel Worksheet Functions	2	November 8th 04 02:07 AM

All times are GMT +1. The time now is 01:39 AM.

About Us

"It's about Microsoft Excel"