I was recently assisting a team from the UK that needed to reformat their sort codes for bank relationships, prior to importing. The problem was two-fold: leading zeros were dropped by Excel, and the number didn't contain the requisite dashes. After a little work, we found a Regular Expression that would fix both of these issues. I hope it helps you too!
*If you have any other suggestions for handling bank info, let us know!*