I have a list of names in column A and a list of dates in column B.
In column C, I'm simply trying to write the formula: =A1&" "&B1
But the date part is coming through as a Julian Date rather than just a normal date. Is there any way of stopping this?
Formula returns: NameOne 42373