Try adding...

+0

....at the end of the formula.

Hope this helps!

In article ,
Tim wrote:

The formula to remove the text from the boxes works a treat, but is there a
way that the results show as a number and not text so i can SUM the numbers
up?

Tim