View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
default time to PM after 12:00 pm default time to PM after 12:00 pm is offline
external usenet poster
 
Posts: 1
Default default time to PM after 12:00 pm

Currently Excel defaults to AM when entering a time. Does anyone know if I
can make default to PM when entering a time I know should be after 12:00pm?
I can't figure out how I can let Excel know I mean 1:00 PM rather than 1:00
AM without typing in the PM.