G
Guest
I have cleared everything is the cell, etc. Nothing has worked.
Please advise.
Please advise.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Chip Pearson
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
message
news:[email protected]...
date? You should not.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
message
news:[email protected]...
G
Gord Dibben
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
On Mon, 24 Apr 2006 11:29:03 -0700, Sun Devil <Sun
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
G
Guest
This is what I am entering
19205E00043 when I hit enter that is what I get 192E+50
19205E00043 when I hit enter that is what I get 192E+50
C
Chip Pearson
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
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