I think ankursmart is correct. First replace banks with 0, then ltrim and rtrim spaces and final replace reminding (non-leading) spaces to 0.

I had similar problem few months ago. Beside removing leading 0 I had to align text to the right site and the final string had to be exactly 10 characters long.

Sample (before):
Sample (after):
If I remember correctly beside replace, ltrim, rtrim, replace functions I have also used length, case and space functions.

Hope this helps,
Grofaty