I have several cells that different Date and Time have to be entered by
several different people, my problem is that I can not seem to get everyone
to enter the date and time the same way, some of them will put the date first
and some the date second, some use dashes and some backslashes and so on. How
can I set the cell to show something like _ _ /_ _/_ _ _ _ _ _ : _ _ . I
have this format in my ACCESS but how do I get it in EXCEL.