You can use a custom format of 000000, but by width, do you mean that if the
cell is widened it gets extra leading digits?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Max_Rebo1" wrote in message
...
I am trying to format existing data so that instead of being a set amount
of
digits, say 2 for example, it fills out the column based on its width, say
6,
with leading zeros. Example - I have 55122 in a cell that has a width of
6,
and I want it to say 055122. I know that changing the cell format to text
and
re-entering the data would fix this problem, but I want a way to change
the
data without re-entering it.