cell formatting with concatenate VBA

[snowbored]

having a small issue with joining two cells together(no math)

Reference to code:
G1 = 10/03/2008
H1 = 12:03:14

Please Login or Register  to view this content.

The two cells concatenate successfully, however the output is as follows (example)

10/03/2008 0.703078703703704

What I am trying to achieve is:

10/03/2008 12:03:14

Thanks.

[VBA Noob]

Maybe

Please Login or Register  to view this content.

VBA Noob

[snowbored]

awesome. merci VBA noob

full finished code (might be handy to someone)

Please Login or Register  to view this content.