On Mon, 10 May 2010 22:54:11 -0400, "Rick Rothstein"
wrote:

How about this real simple UDF for that condition...

Public Function Numerals(Rng As Range) As Variant
Numerals = Val(Rng.Value)
End Function

Now the OP has both a VBA and a worksheet function solution.
--ron