One other question, why would 108=1:108? shouldn't it be 1:08? is there a fix?

"Gary''s Student" wrote:

in B1 enter:

=LEFT(A1,1) & ":" & RIGHT(A1,4)

--
Gary''s Student - gsnu200828


"M.A.Tyler" wrote:

A1=124.4
Can this be changed to read 1:24.4?