Put 100 in an empty cell and copy it, select the range and do edit paste
special and select multiply
custom format cells as 000000000
if you need to export, insert an adjacent column, use a help formula

=TEXT(A1*100,"000000000")

where A1 is the first cell, copy down as long as needed
select and copy and paste special as values in place, remove the original if
needed
the latter is a method if you need to export these values and retain the
leading zeros

--
Regards,

Peo Sjoblom


"gcotterl" wrote in message
...
In MICROSOFT EXCEL 2000, how do I change:
.12
156.00
5,678.99
10.12

to:
000000012
000015600
000567899
000001012

(without decimals and with leading zeroes).