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.