Thread: How do I change . to : when input in a time sheet by error
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gary''s Student
 
Posts: n/a
Default How do I change . to : when input in a time sheet by error
Just change the format from hh.mm to hh:mm
--
Gary's Student


"geordie" wrote:

Have a time sheet, when entering time if I enter it as 09.30 how can I have
the system change this automatically to 09:30 when I enter it?
Reply With QuoteReply With Quote