View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Geoff C Geoff C is offline
external usenet poster
 
Posts: 40
Default 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