I have 4 cells that I need to combine into one cell. One cell has a
time in it. When I combine cells it does not come up as time but a
fraction.
A1 8:30
B1 A
C1 Cards
D1 Indians

My formula is =+A1&" "&+B1&" "&+C1&" "&+D1
I get this
0.354166666666667 A Cards Indians
I want
8:30 A Cards Indians