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?
This should suffice
adjust date format as required
Your absolutely right DLL
All very useful and works a treat with a litle tweeking.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1