View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
 
Posts: 1,231
Default 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.