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

Copper Contributor


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 Replies
best response confirmed by AnnaEss (Copper Contributor)

@AnnaEss Like this perhaps?

Screenshot 2023-08-09 at 06.25.07.png

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.

perfect, thank you!