View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Neil Neil is offline
external usenet poster
 
Posts: 173
Default Formating time in cells

I want to input time data onto a sheet, in the format of a 24 hour clock
(e.g. 09 45 or 17.30 etc).
However, when I select the hh:mm format from the time format options and
then input, say, 19.30, I get a strange date first and then a time which is
not the time I input.
How do I stop it adding the date and just show the time that I input?