How to convert (not format) serial number to date?

[AnnaEss]

Hello,

I have date and time columns in serial number format which I need in dd/mm/yyyy hh:mm format for another program to read. This means the data in each cell has to be converted to dd/mm/yyyy hh:mm, rather than simply changing the format in excel.

Thanks in advance

[#2 · Accepted solution]

@AnnaEss Like this perhaps?

If needed you can copy/paste values column C to somewhere else to get rid of the formula and keep only the text string with the date/time.

[#3]

perfect, thank you!