Converting text to number, dropping leading zero

I have a macro that goes out to a database and pulls in updated numbers. However the numbers come in as text because they have leading 0's:
011204
011208
011209
015942
017536

The only way I can get the numbers formatted as a number and drop the leading 0 is to click on the yellow exclamation tab that pops up and click, Convert to Number. Is there any way I can write this into my macro to automatically do for me?

I tried selecting the column and reformatting this way but it would not drop the leading zero:

Please Login or Register  to view this content.

Any help would be appreciated! Thanks!

If the range is contiguous you may find:

Please Login or Register  to view this content.

please remember to use code tags when posting any VBA