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

  • Thread starter Thread starter jay45940
  • Start date Start date
J

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?
 
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
 
FSt1 said:
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
Click to expand...
....

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.
 
Back
Top