Hello,

I want to be able to type in military time without having to use the ':' symbol and have it convert to standard time with AM/PM showing at the end (example, type "1400" and end up with "2:00 PM").

Does anyone know how to do this?? I am fairly new to the whole excel thing so in more simpler terms would be appreciated! Thanks for your help,

Valerie