If you don't want it to be an actual time that you can manipulate
mathematically then you can just use text functions

=IF(LEN(A2)=3, LEFT(A2, 1) & ":" & RIGHT(A2,2), LEFT(A2,2) & ":" &
RIGHT(A2,2))
Where the number is in Cell A2.

Cools function (without having tried it) is giving you the time, but it
needs to be re-foramtted. Select the cell with the formula and change the
format from general to Time... It should then look correct...

HTH


"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?