Hi
I think you'll need VBA. See:
http://www.cpearson.com/excel/DateTimeEntry.htm
--
Regards
Frank Kabel
Frankfurt, Germany
BulaMan wrote:
The default time format is AM. I would like to create a format for
cells that will only have PM entries. When someone writes 2:00, it
will automatically upon exiting cell create 2:00 PM. I've looked in
help and tried alterations of the General Time Format - No Luck. Is
this a can do? BULAMAN