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