1543 becomes 001543
17626 becomes 017626

This column has thousands of numbers and will convert to text if I have to
but I would like to have the cell display and store them as 6 digit numbers
with a leading zero or two. I am uploading these numbers to an application
that sees 1543 as 001543.

Thank you.