View Single Post
  #5   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

Thanks, I will give it a try.

"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