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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sun Devil - 24 Apr 2006 19:29 GMT

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

Please advise.

Reply to this Message

Chip Pearson - 24 Apr 2006 19:36 GMT

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

Signature

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

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

Reply to this Message

Sun Devil - 24 Apr 2006 20:51 GMT

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

> Are you including the leading = character when you enter your
> date? You should not.
>
> >I have cleared everything is the cell, etc. Nothing has worked.
> >
> > Please advise.

Reply to this Message

Chip Pearson - 24 Apr 2006 20:56 GMT

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.

Signature

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

> This is what I am entering
> 19205E00043 when I hit enter that is what I get 192E+50
[quoted text clipped - 6 lines]
>> >
>> > Please advise.

Reply to this Message

Gord Dibben - 24 Apr 2006 20:37 GMT

Tools>Options>Transition.

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

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

Reply to this Message