text to number

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.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Norm" wrote:

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