On Wed, 26 Jul 2006 15:28:39 -0400, TaGY2K
<TaGY2K.2bkhw5_1153942213.443@excelforum-nospam.com> wrote:
>
>How do you extract the fraction out of column A and put the fractional
>in column B...
>
>example
>
>A B
>
>25.375 .375
>7.975 .975
>7.25 .25
>7.25 .25
>7.25 .25
>87
=MOD(A1,1)
or
=A1-INT(A1)
--ron
Bookmarks