No easy way, a custom format can present it like that (h:mmAM/PM), but
there's no equivalent of an informat.
You may be able to adapt the VBA solution at
http://www.cpearson.com/excel/DateTimeEntry.htm
"Chris Cornell" wrote:
I would like to format a cell for am/pm without having to use a space in the
middle.
ex 12:00 AM
I would like to type in it as
ex 12:00AM