I looked into the link you sent me but wouldnt that refer my cells to
military time? I am looking for a way the cells can refer AM/PM

"Geoff C" wrote:

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