Exacting the fractional

[TaGY2K]

How do you extract the fraction out of column A and put the fractional in column B...

example

A

25.375
7.975
7.25
7.25
7.25


B


.375
.975
.25
.25
.25

[Dave Peterson]

=mod(a1,1)
or
=a1-int(a1)

Do you get what you want with negative numbers?

TaGY2K 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
>
> --
> TaGY2K
> ------------------------------------------------------------------------
> TaGY2K's Profile: http://www.excelforum.com/member.php...fo&userid=1861
> View this thread: http://www.excelforum.com/showthread...hreadid=565313

--

Dave Peterson

[TaGY2K]

thanks work..

[Ron Rosenfeld]

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