Hi guys and Gals.
I've got a sheet with 3 Cells Populated.
A1 has a name
B1 has a time
C1 has a date
In Cell D1 I want to combine all three Cells together (with a | between then)
using =a1 &"|"&b1&"|"&c1"|"
My problem is that the DATE and TIME does not show correctly, due to formatting. The show as 36925 (date???) and 0.46656532 (time??)
any body got any idea how i can change all that?
Cheers!
Bookmarks