Leading and Trailing Zeros

I have a list of numbers with varying lengths. I need to format the list of numbers so that they all end up the same.
The requirements for the numbers are as follows:
1. They need to be a length of 9-digits.
2. They need to have one leading zero
3. If they don't meet the 9 digit requirement, the extra "blanks" need to filled with trailing zeros.

For example:
Currently I have,
508617
11753
11868
35846500
11886500
11730501

I need the list to display,
050861700
011753000
011868000
035846500
011886500
011730501

Thanks in advance.

Maybe:

Please Login or Register  to view this content.