Convert Text to Number - Large Database

Hello All,

I need help! I've researched everyway to convert text t numbers. I'm running a database of inventory numbers. The format of the numbers are:

####-##-###-####

I have 2000+ numbers is coloumn B.

There are a lot of sets of numbers that are still text! It's highly annoying and I need to analyze the data in Access.

I tried the paste special advice and the 3 ways microsoft suggests. I have a feeling its not working because of the required format that I need.

I need to do this project tonight!

Background: these are imported numbers, I had to combine other excel databases... By the way, is their an easier way to combine excel sheets into 1?


THANKS SO MUCH!!