Convert numbers

  • Thread starter Thread starter GARY
  • Start date Start date
G

GARY

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.
 
Back
Top