Changing numbers from text format to number format

Hello all!
I have a large macro that copies data around and formats some of it.
The data I am working with comes from the internet, so any numeric values are in text format.
I am trying to use the following code to change those numeric values back to numeric format:

Please Login or Register  to view this content.

This WOULD work, however I have a mix of values. Some of my values are "123456" while others may be "123-456" or "ABC-123-456"
I only want the actual numeric values changed (123456).
The code above will error out on anything that is not in numeric format.

Can someone provide some extra code that would do this for me?
Thanks!

Maybe:

Please Login or Register  to view this content.

Dom