Help me convert a number strong to Date and time format, please.

[tjwm202]

A strange one

I've exported a lot of data from my website. For some reason the event time/date data has been exported as a 10 digit number string. I have no idea how to convert this into useable information, but it seems that it's possible (from a little Googling) - but it's not clear how. Can anyone help me?

An example:

Start date: Tue Mar 12, 2013, 19:30
End date: Tue Mar 12, 2013, 22:00

comes out as:

Start date: 1363116600
End date: 1363125600

Can any bright spark help me convert the number string back into some sort of date and time format? I'd be hugely grateful.

I'm running Excel 2011 14.7.7 on a Mac

[Root_]

Cannot test it on a Mac at the moment, but for Win Excel it would be:

=A1/86400+"1/1/1970"

[tjwm202]

You absolute legend. Thank you so much!