how to create leading zeros on variable length numbers
Which, indeed, can be simplified to
=REPT("0",15-LEN(A1))&A1
--
Kind regards,
Niek Otten
"Niek Otten" wrote in message
...
=IF(ISTEXT(A1),REPT("0",15-LEN(A1))&A1,TEXT(A1,"000000000000000"))
--
Kind regards,
Niek Otten
"MVPitts" wrote in message
...
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?
|