State numbers beyond decimal point as integer

Hello Excel friends,

Do you know if there is any way to state the values beyond the decimal point of a given number as an integer? As an example, I have the number 1.3579 in cell A1. I would like to put a formula in cell B1 that will yield the number 3579. The number in B1 would correspond to the values beyond the decimal point of the number in A1, stated as an whole number.

This would be easy to do manually: One would just have to delete the number(s) to the left of the decimal point and then delete the decimal point itself. However, I will be working with a lot of numbers which will be updated dynamically and quite frequently, making manual adjustments impossible.

Would any of you Excel wizards have a suggestion on how to approach this challenge?

Thanks so much,

Steven

Originally Posted by daddylonglegs

Are there always 4 decimal places or might that be variable? What about a number like 1.0003, do you want to retain the leading zeroes like 0003 or should that give you just 3?

Good question. In the example you gave, I would be using the number 3, not 0003. I have to find the GCD of the number beyond the decimal point and 10^10. However, if there are 0s in front of the non-zero value(s) beyond the decimal, I will omit the zeros.

Looking forward to understanding more,

Steven

Originally Posted by teylyn

So, what would be your expected results for

1.3
1.30
1.03
1.003

I am carrying out the original numbers to 10 decimal places, so the first two numbers you listed would come out as 3 with 10 zeros, the 3rd number would be 3 with 9 zeros, and the 4th number would be 3 with 8 zeros.

Thanks,

Steven

Will this do?

=(ABS(A1)-INT(ABS(A1)))*10^10

Originally Posted by MarvinP

Will this do?

=(ABS(A1)-INT(ABS(A1)))*10^10

Thank you very much, friends. Both your solutions, Marvin and DaddyLongLegs work perfectly!

Steven