Forum Discussion
Solved
How to convert (not format) serial number to date?
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...
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.
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.
perfect, thank you!