Getting numbers on the right side of the decimal point
 

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

Getting numbers on the right side of the decimal point
 

If it is always 2 decimals

=MOD(A1,1)*100

--


Regards,


Peo Sjoblom

"Tigerxxx" wrote in message
...
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

Getting numbers on the right side of the decimal point
 

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

"Peo Sjoblom" wrote in message
...
If it is always 2 decimals

=MOD(A1,1)*100

--


Regards,


Peo Sjoblom

"Tigerxxx" wrote in message
...
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

Getting numbers on the right side of the decimal point
 

=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.
--
John C


"Tigerxxx" wrote:

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

Getting numbers on the right side of the decimal point
 

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 wrote:

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

--

Dave Peterson

Getting numbers on the right side of the decimal point
 

Thank you All!
Your solutions helped me!

"Dave Peterson" wrote:

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 wrote:

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

--

Dave Peterson