You can set a custom format, which will DISPLAY the leading zeros, but they
won't really be there. Format-Cells-Number-Custom and use 000000 (for a
total of 6 digits) or 00000000 (for a total of 8 digits).

If you really need to change the VALUE and the DISPLAY, in an empty column
use a formula like =Text(a2,"000000"). This creates a 6 digit, zero-padded
value. You'll have to copy the formula and Edit-Paste Special-Value over the
orgiinal values to convert them to zero-padded values

"TDL" wrote:

Hhow do I (left) zero fill a right aligned set of numbers without inserting
each one manually?