My data is currently formatted with a separate column date (5/08/2009) and time (11:16:00). I need to combine them into one datetime column that reads like this (5/08/2009 11:16:00). I have tried the using the =A1&" "&B1 formula as well as =concatenate but both give me this number 39941 0.469444444444444. Acceptable formats for the program I am using would be dd/MM/yyyy H:mi or yyyy.MM.dd H:mi:s. I am using 24hr time. Please help. I have over 1400 data entries and really do not have the time to retype them all. Thank you.

-Mitch