I have some code that uses instr & len to extract a code from a cells value then :

Selection.Value = _
CStr(Right(Selection.Value, L - spc ))
Selection.Offset(1, 0).Select
this should leave the cell with 0999 but instead it ends up 999

how can i change that?

figured it out :


I have some code that uses instr & len to extract a code from a cells value then :

Selection.Value = "'" & _
CStr(Right(Selection.Value, L - spc ))