I'm sure that this question has been asked before on this forum, but I want to convert text into numbers, e.g. I have SP data that is stored as text such as 100/1, 20/1 etc which I wish to convert to a numeric format.

Can anyone help please.