View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kidsmeasy kidsmeasy is offline
external usenet poster
 
Posts: 7
Default change regular 24 hour format to military time in excel

I tried the format but when I input the time and then tab to the next cell
the numbers turn to all zeros.

"Rick Rothstein (MVP - VB)" wrote:

If you mean leading zeroes and without the colon, then Custom Format the
cell with hhmm.

Rick


"kidsmeasy" wrote in message
...
I am trying to create a format for military time in excel