View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith Fred Smith is offline
external usenet poster
 
Posts: 623
Default How to format cells

If you want an easy way to type in times, use 24-hour format. Then you never
need the am/pm. You can still display it in 12-hour format. If that's not
acceptable, the next best is that you don't have to enter an 'am'. You do have
to enter 'pm' (with a space).

--
Regards,
Fred


"Chris Cornell" <Chris wrote in message
...
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