One of the fields in the excel file that I have linked to is a text field representing numbers. For instance:
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
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