Try this ..

Enter in an empty cell: 100, and copy the cell

Select and right-click on the target range
Choose Paste special Multiply OK

With the target range still selected
click Format Cells Custom
Enter in the "Type:" box: 000000000
(Enter 9 zeros)
Click OK

Perhaps another alternative to play around with,
if *text* results are acceptable

Assume the target range of numbers is in A1:A4

Put in B1: =TEXT(A1*100,"000000000")
Copy down to B4

B1:B4 will return the results indicated, but in *text* format.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"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).