software

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

Please advise.

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.comquot;Sun Devilquot; lt;Sun gt; wrote in
message
...
gt;I have cleared everything is the cell, etc. Nothing has worked.
gt;
gt; Please advise.
Toolsgt;Optionsgt;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

On Mon, 24 Apr 2006 11:29:03 -0700, Sun Devil lt;Sun
gt; wrote:

gt;I have cleared everything is the cell, etc. Nothing has worked.
gt;
gt;Please advise.This is what I am entering
19205E00043 when I hit enter that is what I get 192E 50

quot;Chip Pearsonquot; wrote:

gt; Are you including the leading = character when you enter your
gt; date? You should not.
gt;
gt;
gt; --
gt; Cordially,
gt; Chip Pearson
gt; Microsoft MVP - Excel
gt; Pearson Software Consulting, LLC
gt; www.cpearson.com
gt;
gt;
gt; quot;Sun Devilquot; lt;Sun gt; wrote in
gt; message
gt; ...
gt; gt;I have cleared everything is the cell, etc. Nothing has worked.
gt; gt;
gt; gt; Please advise.
gt;
gt;
gt;

19205E00043 doesn't look like any sort of date. The 'E' in the
data indicates quot;power of 10quot; so Excel is interpreting the data as
19205*10^43.--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
quot;Sun Devilquot; gt; wrote in message
...
gt; This is what I am entering
gt; 19205E00043 when I hit enter that is what I get 192E 50
gt;
gt; quot;Chip Pearsonquot; wrote:
gt;
gt;gt; Are you including the leading = character when you enter your
gt;gt; date? You should not.
gt;gt;
gt;gt;
gt;gt; --
gt;gt; Cordially,
gt;gt; Chip Pearson
gt;gt; Microsoft MVP - Excel
gt;gt; Pearson Software Consulting, LLC
gt;gt; www.cpearson.com
gt;gt;
gt;gt;
gt;gt; quot;Sun Devilquot; lt;Sun gt; wrote in
gt;gt; message
gt;gt; ...
gt;gt; gt;I have cleared everything is the cell, etc. Nothing has
gt;gt; gt;worked.
gt;gt; gt;
gt;gt; gt; Please advise.
gt;gt;
gt;gt;
gt;gt;