View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] data08@yahoo.com is offline
external usenet poster
 
Posts: 1
Default Converting data download for date 2.00707E+11 into something more user-friendly

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!