What I am about to say, is normal in QB45. <------
In a=VAL(A$) example. The variable 'a' becomes the numerical representation of A$. Conversion using VAL converts until a non-numeric value is encountered. This is unless prefixed by &x. X being some base like hex (&H). My high school days I was taught 0-9 are numerical. A-F are accepted for hex. Keeping that in mind, what do the following conversions output ?
5555
5 5 5 5
5555G4444
5 5 5 5 G 4 4 4 4
&H15B3
If you say 5555 you are right!! Now the gotcha. Why is space considered a numeric ? A leading space yes, to determine negative or positive numbers. But space in between all numbers. Give me a break. Even Wikipedia gave a non-answer answer (best I could find).