Filtering out a few numbers in a large group of numbers

I have a column of numbers that look like this:

0000054554-88774


I need only the "54554", not the leading 5 zeros or the dash and trailing numbers. This is the exact format. Excel 2010.

Help?