How to format cells
 

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