controlled cell formatting

I need to format cells to seven digits and a letter (e.g. 0123456H). Some of my numbers have 6, 5, or 4 digits and the letter. So I would need to have leading zeros to bring the numbers to seven digits and the letter already in place. Any help please? thanks

Tony

Try =right(" " & A1, 8)

Thanks a lot, but your formula didn't give me what I was expecting. I tried using IF and worked out a formula using LEN as follows and it worked.

=IF(LEN(A1)=4,"0000"&A1,IF(LEN(A1)=5,"000"&A1,IF(LEN(A1)=6,"00"&A1,IF(LEN(A1)=7,"0"&A1,""&A1))))

Thanks just the same maybe this might help others.