Switching to number from text

Hi!
I was wondering if anyone has a solution for this access problem.
After importing another database to access the numbers enters as a text value. When I try to switch the value into a numer the value changes. It becomes a totally different value that is a lot larger.

Hi!
I was wondering if anyone has a solution for this access problem.
After importing another database to access the numbers enters as a text value. When I try to switch the value into a numer the value changes. It becomes a totally different value that is a lot larger.