Hi,
DOes anyone know of a find and replace function that will search through
cells and located
:23:45
:12:45
:34:54
And change to
0:23:45
0:12:45
0:34:54

In addition there are numbers in there already that have leading digits
(1:24:34 for example) I don't want the formula to alter those numbers.

Thanks in advance,

Intotao