Remove Decimal and Make 11 Numbers

[richmcgill]

I need to be able to remove the decimal from a number but keep the cents and make the complete number 11 digits.

9.85 would be 00000000985
100.75 would be 00000010075
11111.90 would be 00001111190

Make sense?

I appreciate the help!

 

[DanteAmor]

Try

Libro1
	A	B
2	9.85	00000000985
3	100.75	00000010075
Hoja1

Cell Formulas
Range	Formula
B2:B3	B2	=TEXT(A2*100,REPT("0",11))

 

[richmcgill]

Try

Libro1
	A	B
2	9.85	00000000985
3	100.75	00000010075
Hoja1

Cell Formulas
Range	Formula
B2:B3	B2	=TEXT(A2*100,REPT("0",11))

Thank you so much for your help!

Have a great Holiday.