| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting data download for date 2.00707E+11 into something more
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking for a production schedule excel/access & user friendly? | Setting up and Configuration of Excel | |||
| Drill to Details - is there user friendly way to delete the sheet | Excel Worksheet Functions | |||
| entering data using - between numbers without converting to date | Excel Discussion (Misc queries) | |||
| Bar chart No printer friendly. | Charts and Charting in Excel | |||
| how to get hyperlink from the friendly name in xl. | Excel Discussion (Misc queries) | |||
Hybrid Mode
