Rick

am I right in thinking that this looks OK but it's not actually a time value
?

Regards

Trevor


"Rick Rothstein (MVP - VB)" wrote in
message ...
Did you try using a Custom format like this..

#0\:00\:00

Rick


"JS" wrote in message
...
I have imported data into excel and one column contains the military time.
It is displayed as below. How can I insert a ":" for the entire column
in
the correct place. I have not been able to do it through Format-Cells
menu.

160526 16:05:26
90928 9:09:28
92155 9:21:55
110101 11:01:01

Thanks,
JS