Convert column of 4-5 digit whole numbers to 6?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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.
.

Relevant Pages