I have two cells: A1 and B1 

* A1 has data in format of `mm/dd/yyyy`
* B1 has data in format of `hh:mm:ss`

When I concatenate the two cells A1 and B1 using VBA, the output contains has the format `mm/dd/yyyy hh:mm`. Why are the seconds not displaying? How can I fix this?

Note : 

a) After concatenation the output is copied to A1. 

b) I tried changing the format of date to `dd/mm/yyyy`, in this case its working fine .