how to create leading zeros on variable length numbers

M

MVPitts

I have a column of variable length numbers/text (6-12 characters). I need to
place leading zeros in each of the cells to create a standard length of 15
characters. What's the easiest way to do this?
 
G

Gary''s Student

sleect cells or column then pull-down:

Format > Cells... > Number > Custom > and enter 000000000000000
in place of general
 
F

FxM

MVPitts said:
I have a column of variable length numbers/text (6-12 characters). I need to
place leading zeros in each of the cells to create a standard length of 15
characters. What's the easiest way to do this?
Click to expand...

Hi MVPitts,

Try :
=right(REPT("0",15) & "text" , 15)

@+
FxM
 
Top