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