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

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.

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

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.

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

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



"Duke Carey" wrote:

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.

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

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

Rick


"Duke Carey" wrote in message
...
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.