I don't have the option of just changing the forma
Convert Serial number to Time. Xl 97—– Use xdemechanik yahoocom for email > I have a serial number that I need to convert to time in a vba macro
In addition 5- Enter activation key.
Select the cells with serial number that you want to convert to date, right
Convert-License – technet.Microsoft.Com
Excel: convert text to date and number to date – Ablebits.Com
It offers various functions to perform this task.
XE Currency Converter – Live Rates