Hi
Thanks for any help in advance.

In the UK banks have sort code and account number...

Sort code is 6 digits long for example 001122

Account number is 8 digits long say 01234567

My question is that if the first digit s a zero then sometimes in get chopped of. Is there a formula I can use so that it doesn't remove this leading "0"


If not possible then how could I add say "SC00000" into the cell but just by adding "00000". the SC would be added from a formula.

Thanks