Use MOD

=MOD(A2,1)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"gramsey" wrote in message
...

I am wanting to carry out a calculation on only one part of a particular
result in a calculation made in a spreadsheet

ie if i have the result of "2.57945" how do i get excel to then only
select the digits after the decimal point for further calculations ie
".57945" bearing in mind the whole number will not always be a fixed
value.


--
gramsey
------------------------------------------------------------------------
gramsey's Profile:
http://www.excelforum.com/member.php...o&userid=16143
View this thread: http://www.excelforum.com/showthread...hreadid=275773