I am entering date in Excel when I hit enter a formula appears?
 

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

Please advise.

I am entering date in Excel when I hit enter a formula appears?
 

Are you including the leading = character when you enter your
date? You should not.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Sun Devil" <Sun wrote in
message
...
I have cleared everything is the cell, etc. Nothing has worked.

Please advise.

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.

I am entering date in Excel when I hit enter a formula appears
 

This is what I am entering
19205E00043 when I hit enter that is what I get 192E+50

"Chip Pearson" wrote:

Are you including the leading = character when you enter your
date? You should not.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Sun Devil" <Sun wrote in
message
...
I have cleared everything is the cell, etc. Nothing has worked.

Please advise.

I am entering date in Excel when I hit enter a formula appears
 

19205E00043 doesn't look like any sort of date. The 'E' in the
data indicates "power of 10" so Excel is interpreting the data as
19205*10^43.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Sun Devil" wrote in message
...
This is what I am entering
19205E00043 when I hit enter that is what I get 192E+50

"Chip Pearson" wrote:

Are you including the leading = character when you enter your
date? You should not.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Sun Devil" <Sun wrote in
message
...
I have cleared everything is the cell, etc. Nothing has
worked.

Please advise.