Quote: "Do what LBFN said"
Why would you recommend someone ignore the correct information and follow something which is incorrect?
What LBFN suggests doing has nothing to do with what Ben actually asked for advice on as ASCII codes are unrelated to the actual value of a number held as a string, (I think he just mis-read the opening post).
Quote: "be careful though, if you have ANY letters in the string at all then VAL(A$) will return 0."
Not true. Even if the string contains numeric characters at the front and alpha characters on the end, VAL() will still work.
A$="123 This is a mixed string"
X = VAL(A$)
Print X
... will still print 123!
TDK_Man