|I imported data from another program into Excel and it is giving me the date and time in this format:|
I need it to look like this:
The data is in Cell R72. When I use the formula below, it comes up as 8/15/03 1:40 instead of 10/01/2015 01:40.
Any help would be appreciated!
message edited by rajasperson