Try this:

=--TEXT(A1,"0000\/00\/00 00\:00")

Format cells as : date


" 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!