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

Hi!

Multiply by 100:

=A1*100

Format the cells as CUSTOM:

000000000

Biff

"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

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

When I tried Biff's suggestion: =A1*100 then formatted the cells as
CUSTOM and 000000000, the format would change to SPECIAL.

When I tried Ragdyer's suggestion: =TEXT(A1*100,"000000000"), the
format did not change and I got the results I needed.