1,000.0000000 Text Value Desired number value 1000

1.0000000 Text Value Desired number value 1

1.0050000 Text value Desired number value 1.005

I have tried to use the Val vunction in a querry, but since the 1,000.000000 has a comma right after the 1, the function is returning a value of 1 instead of a value of 1000.

Can come one please let me know how to convert text numbers into values when there are both "," and "." in the string??

Kevin