I have cleared everything is the cell, etc. Nothing has worked. Please advise.
S Sun Devil Apr 24, 2006 #1 I have cleared everything is the cell, etc. Nothing has worked. Please advise.
C Chip Pearson Apr 24, 2006 #2 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]...
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]...
G Gord Dibben Apr 24, 2006 #3 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
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
S Sun Devil Apr 24, 2006 #4 This is what I am entering 19205E00043 when I hit enter that is what I get 192E+50
C Chip Pearson Apr 24, 2006 #5 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
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
