Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Time
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mileage Claim Formula | New Users to Excel | |||
Calculating Difference Between Start Date & Time And End Date & Ti | Excel Discussion (Misc queries) | |||
change date based on time | Excel Discussion (Misc queries) | |||
How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
Help - Information with time and date | Excel Discussion (Misc queries) |