Can I reduce (101.25) to only what's *right* of decimal? (25)

[jay45940]

Can I reduce (101.25) to only what's *right* of decimal? (25)
Is there a function or a series of steps to accomplish this within an excel
spreadsheet?

 

[FSt1]

hi
=MOD(A1,1)

this will get you what is right of the decimal which is .25. however your
example was 25 so just multiply by 100.

=MOD(A1,1)*100

adjust cell reference to suit.
regards
FSt1

 

[Harlan Grove]

hi
=MOD(A1,1)

this will get you what is right of the decimal which is .25. however your
example was 25 so just multiply by 100.

=MOD(A1,1)*100

....

Probably OK, but MOD will fail when A1 > 2^29. Safer to use

=A1-TRUNC(A1)

or

=SUBSTITUTE(A1-TRUNC(A1),"0.","")

The latter returns a text string which would retain leading zeros.