Carol
if i read you correctly you need timeserials

add a temporary column..

if the last 2 digits are seconds then
with formula =TIMEVALUE(TEXT(B1,"00\:00\:00"))
if they are minutes then
with formula =TIMEVALUE(TEXT(B1,"00\:00"))

dragdown.. then copy /pastespecial values..





--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Carol Wolfe wrote :

I have a column of 3 and 4 digit numbers. I would like to insert a
colon : to the immediate left of the 2 numbers on the far right of
the cell. Is there a way to do this easily?