No, 2.00707E+11 is 2.00707 * 10^11; this is how Excel displays
scientific notation.

Try formatting the cell as text?


On Aug 2, 11:52 am, wrote:
Received a data download into Excel and noted that the date is listed
as "2.00707E+11" [which is basically 200707011300 and includes
YYYYMMDDHHMM]. I tried converting it to other date formats but got
this
"################################################# #########################*######################## ################################################## #*################################################ ###########################*###################### #########"
instead. Please HELP. Thanks in advance!