Private Sub Worksheet_Change(ByVal Target As Range)
Dim pl As Range, c As Range
Set pl = Intersect(Target, Columns(1))
If Not pl Is Nothing Then
For Each c In pl
If UCase(Left(c.Value, 4)) = "RIB:" Then
Application.EnableEvents = False
c.NumberFormat = "@"
c.Value = Mid(c, 12, 16)
Application.EnableEvents = True
End If
Next c
End If
End Sub