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

  • Thread starter Thread starter Professor_Higgins
  • Start date Start date
P

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.
 
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.
 
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 :-).
 
This question was answered to the OP's satisfaction in a duplicate posting
to the programming newsgroup.

Rick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

4-5 digit numbers to display leading zeros totalling 6 digits 2
Need 7 digit number with differnt number of leading zeros 10
In Excel find 5 digit number and replace with leading zero 2
VBA Macro change column contents 4
Best Ways to Convert OST to PDF? 4
How Can I Convert MBOX to HTML File? 2
How can you format cells in a column to display a 50 digit binary 3
QUICK FORMAT WITH APOSTROPHE 5

Back
Top