Well, professor, to have Excel DISPLAY and STORE them with leading zeroes,
you'll have to convert them to text values with the formula:

=text(value,"000000")

Copy that formula down for each cell in your range, then select all the
formulas and Copy then, without changing the selection, use Edit-Paste
special- Values. Be sure to format the range as text.


"Professor_Higgins" wrote:

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.