Hi,

I run a text report from our software & then I open that
text report into XL (Delimited Function). One of the
column has time & it is in the order of HHHH:MM:SS

Sometimes if the column has only minutes & seconds, I will
see :MM:SS OR if only seconds then :SS - I have to convert
the formating of every single cell & manually change the
numbers. I am using XL 97 & its really pain in the neck to
change every single cell. I am wondering if anyone can
tell me an alternate way of handling this issue or create
a macro to add 0's automatically infront of the colons
instead of doing it manually.

Thanks,

Kash