Excel file import date as exponential (e.g. 1.74E+09) value to date format?
<p>I opened an Excel file with a column <code>Time</code> having date and time as values. When uploaded into Excel, though, the dates I used to have are now represented in exponential notation, e.g. <code>1.74E+09</code> and <code>1.75E+09</code>). What date format can I use in Excel to convert these numbers to something following <code>dd/mm/yyyy hh:mm:ss</code>, or at the very least, <code>yyyy/mm/dd</code>?</p>