Converting your value in milliseconds to days is simply (MsValue / 86,400,000)
We can get 1/1/1970 as numeric value by DATE(1970,1,1)
= (MsValueCellReference / 86400000) + DATE(1970,1,1)
Using your value of 1271664970687 and formatting it as dd/mm/yyyy hh:mm:ss
gives me a date and time of 19/04/2010 08:16:11
Related Contents:
- What is a correct MIME type for .docx, .pptx, etc.?
- What is correct content-type for excel files? [duplicate]
- Setting mime type for excel document
- Excel VBA – exit for loop
- How to correctly display .csv files within Excel 2013?
- How can I perform a reverse string search in Excel without using VBA?
- How can I send an HTTP POST request to a server from Excel using VBA?
- Remove leading or trailing spaces in an entire column of data
- How to suppress Update Links warning?
- How do I use FileSystemObject in VBA?
- Leave out quotes when copying from cell
- When should the xlsm or xlsb formats be used?
- Why on earth can’t Excel handle 2 files with the same name? [closed]
- Excel formula to reference ‘CELL TO THE LEFT’
- What is the difference between dim and set in vba
- How to add a reference programmatically using VBA
- automatically execute an Excel macro on a cell change
- Append same text to every cell in a column in Excel
- Iterate over VBA Dictionaries?
- Excel Macro : How can I get the timestamp in “yyyy-MM-dd hh:mm:ss” format?
- Way to run Excel macros from command line or batch file?
- Excel: How to check if a cell is empty with VBA? [duplicate]
- Refresh Excel VBA Function Results
- Can Excel interpret the URLs in my CSV as hyperlinks?
- How to add a named sheet at the end of all Excel sheets?
- How to use workbook.saveas with automatic Overwrite
- How can I use a for each loop on an array?
- How to change Format of a Cell to Text using VBA
- Using a UDF in Excel to update the worksheet
- Setting Column width in Apache POI
- Obtaining the equivalent to printf or String.Format in Excel
- Using “If cell contains #N/A” as a formula condition.
- Substring in excel
- Excel: Scalar product of two ranges
- Why cells(1,1) = 500 * 100 causes overflow but 50000*100 doesn’t?
- How to activate a specific worksheet in Excel?
- Excel add one hour
- How to add a button programmatically in VBA next to some sheet cell data?
- How to Remove Line Break in String
- Quadratic and cubic regression in Excel
- OleDB & mixed Excel datatypes : missing data
- Setting filter on headers of an Excel sheet via POI
- excel delete row if column contains value from to-remove-list
- Add common prefix to all cells in Excel
- Excel 2013 VBA Clear All Filters macro
- If WorkSheet(“wsName”) Exists [duplicate]
- VBA Excel sort range by specific column
- Sum of row n through last row
- How to give a time delay of less than one second in excel vba?
- Create a folder and sub folder in Excel VBA