View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dan E[_3_] Dan E[_3_] is offline
external usenet poster
 
Posts: 53
Default Function that returns decimals only

Rexburgh,

The MOD function returns the remainder from a division, you can get
the decimal portion of a number by dividing by 1... if your value was
in A1:

=MOD(A1,1)

Dan E

"rexburgh" wrote in message ...
Can someone help?

I need to know if there exists an excel function for use to return decimals
only in any given numer.

Example:

1241,17 to be displayed/returned as 17

18,875 to be displayed/returned as 875 etc.



Thanks for any help on this issue.