Try the FORMAT function in VBA . . .look at Format in the
help for VBA. It gives several pretty good examples. I'm
sure something there might work for you . . .just play
around with it until you get what you want.

Hope that helps.

JRL
-----Original Message-----
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
.