Convert Text To Number
 

I have about 15K id numbers I need to convert from text to number. All of the
id numbers end with _, for example, 106102_. I need to import these id
numbers into Access but I can't convert them in Access and I can't figure out
how to convert them in Excel so that I may import them. Can someone help?
Thanks!

Convert Text To Number
 

Hi

If you have ID numbers in column A enter this formula in B1 and copy down.

=(LEFT(A1,LEN(A1)-1))*1

Regards,
Per

"Antney" skrev i meddelelsen
...
I have about 15K id numbers I need to convert from text to number. All of
the
id numbers end with _, for example, 106102_. I need to import these id
numbers into Access but I can't convert them in Access and I can't figure
out
how to convert them in Excel so that I may import them. Can someone help?
Thanks!

Convert Text To Number
 

Say your values are in column A. In B1 enter:

=--SUBSTITUTE(A1,"_","") and copy down

Export the values in column B
--
Gary''s Student - gsnu200794


"Antney" wrote:

I have about 15K id numbers I need to convert from text to number. All of the
id numbers end with _, for example, 106102_. I need to import these id
numbers into Access but I can't convert them in Access and I can't figure out
how to convert them in Excel so that I may import them. Can someone help?
Thanks!

Convert Text To Number
 

Perfect! Thank you!!

"Per Jessen" wrote:

Hi

If you have ID numbers in column A enter this formula in B1 and copy down.

=(LEFT(A1,LEN(A1)-1))*1

Regards,
Per

"Antney" skrev i meddelelsen
...
I have about 15K id numbers I need to convert from text to number. All of
the
id numbers end with _, for example, 106102_. I need to import these id
numbers into Access but I can't convert them in Access and I can't figure
out
how to convert them in Excel so that I may import them. Can someone help?
Thanks!

Convert Text To Number
 

=LEFT(A1,LEN(A1)-1)*1

then copy down

HIH