Can I reduce (101.25) to only what's *right* of decimal? (25)
FSt1 wrote...
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.
|