removing leading zeros

[toddbingham]

I am importing some data (ex., 00012 and 00001) with a link table. Then I am using an append query to dump the info into a table. How can I make the leading zero's disapper and appear as 12 and 1. I thought about setting up the format to exclude the leading zeros, but where there could be 3 or 4 zeros in the field, depending on the last number, I can not do that. Please help.

Thanks.

 

[toddbingham]

Nevermind. Thought I already had the data type set to Number but didnt.

Thanks anyway.