Standardisation of number length

R

Robin D

I have a long list of numbers which I need to convert to a standard length of 8 characters. For example:

5 to 00000005
18 to 00000018
1471 to 00001471

Is there a quick way of doing this rather than manually editing each cell?
 
F

Frank Kabel

Hi
see your other post

P.S.: please don't multipost :)
-----Original Message-----
I have a long list of numbers which I need to convert to
Click to expand...
a standard length of 8 characters. For example:
 

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

Standardising number length 3
Space at end of multi page list to accommodate new entries 1
Adding recognised Zeros 5
Excel does not accept text format! 0
How can the font and size of (all) citation numbers be altered? 1
Page numbering with Merged Document and IF statements 1
Look Up Formula With Veried Search Range 2
Ensure that all numbers are 8 digits long 4

Top