spreadsheet

if C6 is your number, then in another cell
=SUBSTITUTE(C6,RIGHT(C6,2),":" & RIGHT(C6,2))

VBA

Sub Adjust()
Dim cell As Range
Dim text As String
For Each cell In Range("A:A").SpecialCells(xlCellTypeConstants)
text = cell.Value
cell.Value = Replace(text, Right(text, 2), ":" & Right(text, 2))
Next
End Sub

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