text to number

  • Thread starter Thread starter Norm
  • Start date Start date
N

Norm

I have a numbers in a feild in an excell sheet that I need to change from
text to number so I can use the field in a query in Access
 
Show some examples of the text.

If they are all numerical characters, you could use something like the CDbl
function to change them to numbers.

If the numerical characters are at the beginning of the string, something
like a street address of 123 Main St., then you can use the Val function to
extract the leading numbers.

If the numerical characters are spread around in the string, that can be a
problem.
 
Back
Top