Number Extraction from String

[quibilty]

In the attached example I would like to know if there is a formula that will extract the numbers in column "A" and list them in column "C". If possible, I'd like that formula in "C" to round the number to the nearest tenth. If not, I can just round the value from the formula in "C" in "D". The value in "D" is my end goal.

So, if "W -101" is entered in cell "A1" then is there a formula that will produce the value "-100"?
If "W 116" were then entered in cell "A1" instead, then could that same formula in "A1" also produce the value "120"?

[Ron Coderre]

Using your posted workbook

This formula, copied down, extracts the number after the first letter and rounds that number to the nearest multiple of 10

C1: =ROUND(MID(A1,2,10)/10,0)*10

Is that something you can work with?