Date in A1, time in B1, combined in C1: formula is =A1+B1 and format as you
describe.

On Sat, 22 Jan 2005 14:03:02 -0800, "Kelly C"
wrote:

I have the date (m/dd/yy) in one cell and time (hh:mm) in another cell. How
can I merge these two in one cell with the format m/dd/yy hh:mm ?

Thanks.