I am having a problem with the result of this formula.
=A1&B1&C1&D1&E1&F1&G1&H1&I1
A1 is a date and E1 is a time.
The result displays like this.
A1 E1
39291 - Paradise Band - 0.791666666666667 - Twisted Martini PVB -
280-8800
How do I get it to display the date and time properly?
Thanks