having a small issue with joining two cells together(no math)
Reference to code:
G1 = 10/03/2008
H1 = 12:03:14
The two cells concatenate successfully, however the output is as follows (example)Columns("F:F")NumberFormat = "dd/mm/yyyy hh:mm:ss" Range("F1").Value = _ Range("G1").Value & " " & Range("H1").Value
What I am trying to achieve is:10/03/2008 0.703078703703704
Thanks.10/03/2008 12:03:14
Bookmarks