Excel 2007 : help in converting to numbers and filterring

Hi

I inserted a header row in the attached workbook, then used this formula in cell C2
=--MID(B2,3,10)

You can then copy column C and Paste Special>Values back over column B if you wish, and then delete the helper column C.

To get rid of the 0 value rows
Apply an Autofilter to the sheet>Select 0>highlight all the row numbers that are filtered>right click>Delete