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

[Professor_Higgins]

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.

 

[Duke Carey]

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]

Thank you, Mr. Carey:

Sorry, I don't seem to understand this piece:
"Copy that formula down for each cell in your range"

I do appreciate the help! I play a great game of tennis though .

 

[Rick Rothstein \(MVP - VB\)]

This question was answered to the OP's satisfaction in a duplicate posting
to the programming newsgroup.

Rick