hi
it is not possible to add leading zeros to a numeric value. Mathematically,
this is redundent and unnecessary.

opps.
hit the post button too quick.
option 1. custom format
if your numeric value is 12345 then see the custom format to 00000000.
note. format do not change data - it just changes the way it looks in the
cell.
option2. format to text
then use the concatinate function to add the leading zeros.
your numeric values would not longer be numeric values but treated as text
by excel.

regards
FSt1

for each c in range("a2:a200")
c.value="000"& c
next c