how to create leading zeros on variable length numbers
sleect cells or column then pull-down:
Format Cells... Number Custom and enter 000000000000000
in place of general
--
Gary's Student
"MVPitts" wrote:
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?
|