View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
MikeR-Oz MikeR-Oz is offline
external usenet poster
 
Posts: 46
Default 0100 (24 hour) time - Which format??

Hi,

I wish to type in the cells 0100, 0200, 0300 etc but cannot see the format
type that retains these numbers as four digits (allows me to go to 2400) .

Which format is it - I have tried several and it drops the first zero(0) off.

Cheers
Mike