MS Access - Converting text to number

Hi,

I am working with anothet unit's excel document linking it to my DB how ever the format on some of the columns that contain numbers is reading as text and therefore not allowing we to use it in calculations. Is there any way in a query that I can convert the feild to a number so I can use it.

Thanks

Matt