One way:

=TEXT(A1*100,"000000000")

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"GARY" wrote in message
oups.com...
In Column A, the format of the cells is 'number' with 2 decimal-places.

The cells contain:

A

1 0.00
2 1024.52
3 3.79
4 7.63
5 1.00
6 6.99
7 512344.56
8 22.42
9 7.03

What formula do I put in column B so the results are nine-digit numbers
(without the decimal point)? For example:

B

1 000000000
2 000102452
3 000000379
4 000000763
5 000000100
6 000000699
7 051234456
8 000002242
9 000000703