if cells were formated to time (i.e. 00:00:00) but if some only looked
like:

05:00
06:00... How could you add the first series of "00" to them using a
formula.

Basically my data set looks like:

01:00:00
05:00
06:00


and for the final two i wanted to add the other series of zero's, how
would i do that using a formula?


--
Browner
------------------------------------------------------------------------
Browner's Profile: http://www.excelforum.com/member.php...o&userid=33657
View this thread: http://www.excelforum.com/showthread...hreadid=553517