Standardisation of number length

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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:
 
Back
Top