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