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!