Trying to use an Excel Date and Time function, but Excel returns a serial number instead of date; this is because Excel stores dates and times in serial numbers in the backend; for instance, when ...

If you are converting more than one column of text to numbers, this is an excellent method to use. Select a blank cell and type 1 into it. Then press Press CTRL + C to copy the cell.