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