Thread: Time format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
vangerm vangerm is offline
external usenet poster
 
Posts: 1
Default Time format

I have selected 1:30 PM as the format for time. I thought I could just type
in the numbers without the colon and the time would be entered correctly, but
it enters 12:00 AM every time. Is there any way to enter the time without
having to enter the colon?