Microsoft Excel - How to Get Normal Date and Time from File.msg Opened by Excel

Hi Excel Experts,
I have exported all sms from my cellphone to computer file .msg, when I open it by Excel as XML table or read only workbook, the column with local times stamp does not show time of the message like DD:MM:YY HHMMSS instead it shows a very large number.
Example: December 10, 2025 12:32 is displayed 130942135447314000.

How to convert the above 130942135447314000 to normal time as December 10, 2025 12:32

Your inputs is highly appreciated.
Gauss.

Highlight the cells in question and change the cell's format. 

Does the xml file show the dates as you want them if you open it in notepad?

Hello Gauss,

Date/time is usually recorded as a number and just formatted by the relevant software.  In Excel the number is the number of days (and fraction of a day) since 1 Jan 1900.  So, if you put zero in a cell and format it as a date you will get 1 Jan 2026 as the output.

Other systems use the number of seconds (or fractions of a second) since some start date.  One package even uses 0 AD (or CE if you prefer) as the base line.  I have tried dividing out your number in various ways but haven't found a suitable combination just yet.

Perhaps if you searched for something like  'serial date numbers' in combination with your brand of cell phone you mught turn something up.

Meantime, if I crack the code, I'll let you know.

Regards

Harry

Hi. Thank you both for your efforts. I have tried both cell formats and formula to divide but does not work. What happened is I backed up all msgs in my windows phone by using backup and restore software, then by bluetooth I sent the backup file to my computer. When I open it by outlook it does'nt open but with Excel it opens and formats the date/time in that many digits to quiet a huge number, all numbers ends with three zeroes(000). Gauss.

Can you paste a line of the data in a post here when opened from text editor like notepad?

Here is a line how it appear in notepad

<IsIncoming>true</IsIncoming><IsRead>true</IsRead><Attachment/><LocalTimestamp>130982011018785395</LocalTimestamp><Sender>
LocalTimestamp is not different from when opened by XML or Excel.
The file itself is "Outlook Item" but I tried to open by Outlook unsuccessfully.

regards,

That looks like a UNIX based Universal date format. 

https://en.wikipedia.org/wiki/Unix_time

I don't know of an Excel conversion that will do this for you.  Confirm with the creators of the xml file that I'm correct.  If not, it is something similar.