Specify length, affix to prefix

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Hi,
I have a whole list of numbers that I need to fix to have
a lenth of 5 characters. The problem is that I need to add
the 0' s the the front. For example: I have this list of
numbers:
10
12
123
9256
7563
etc. and I need them to look like this:
00010
00012
00123
09256
07563
etc.
I really appreciate any help that you could give me.
Thanks
 
Custom format
00000
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hi,
I have a whole list of numbers that I need to fix to have
a lenth of 5 characters. The problem is that I need to add
the 0' s the the front. For example: I have this list of
numbers:
10
12
123
9256
7563
etc. and I need them to look like this:
00010
00012
00123
09256
07563
etc.
I really appreciate any help that you could give me.
Thanks
 
Go to Format > Cells in the "number" tab go to custom at
the end of the list and select it then type 5 0's (00000)
under "Type"

Cheers
Juan
 
Back
Top