Change variable length of numbers to three character text

Topic

New Reply

Good Afternoon,

I have a list of numbers
1
05
01
26
427

and I need to change them all to text like
001
005
001
026
427

Does anyone have a quick way to do this?

I also have a mix of numbers that are 5 or 6 digits long. I need to add a leading 0 to the 5 digit numbers and change all the numbers to text.

Any help on these appreciated.

Meleia

Reply | Quote

Replies

If you want to keep them as numbers but display that way, format the cells with a custom number format of 000

To convert to text you could use a fomula like:
=TEXT(A1,”000″)

Then you could copy that column and paste values over the originals.

You can do the similar for the leading zeroes in 5 digit
Steve

Reply | Quote

Thanks for answering so quickly. I will need to convert to text so this works. Now that I read your response I may have asked this before a long, long time ago but just couldn’t remember how to do it. Brain drain.

Thanks again.
Meleia

Reply | Quote