Hi,

Select the data region -- "Format" -- "Cells" -- Select "Custom" under
"Category" -- Enter 000000 under "Type" -- "OK"
(In fact you can see under "Sample", a preview of how the numbers will be
formatted, as you are enter the 0's under "Type")

Regards,
B. R. Ramachandran

"Max_Rebo1" wrote:

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.