Getting numbers on the right side of the decimal point

[Tigerxxx]

What formula can I use to get the numbers on the right side of the decimal?
i.e. for a number 6.25, the result of the formula should be 25.

Thank you

 

[Peo Sjoblom]

If it is always 2 decimals

=MOD(A1,1)*100

--


Regards,


Peo Sjoblom

 

[Peo Sjoblom]

If you always want the number of decimals as integers like if you have

0.12345

and you want

12345

=MOD(A1,1)*(1&REPT("0",LEN(MOD(A1,1))-2))

--


Regards,


Peo Sjoblom

 

[John C]

=RIGHT(A1,LEN(A1)-FIND(".",A1))

It is now 'text', but will keep any preceding zeroes (i.e.: 3.057 = 057) and
will avoid the bad rounding that otherwise might occur.

 

[Dave Peterson]

If none of the suggestions work for you, you may want to explain what you want
when the original number is:

6.5

Do you want 5, 50, 500, ...

 

[Tigerxxx]

Thank you All!
Your solutions helped me!

If none of the suggestions work for you, you may want to explain what you want
when the original number is:

6.5

Do you want 5, 50, 500, ...