Exacting the fractional

[TaGY2K]

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

example

A B

25.375 .375
7.975 .975
7.25 .25
7.25 .25
7.25 .25
8

 

[Dave Peterson]

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

Do you get what you want with negative numbers?

 

[TaGY2K]

thanks work.

 

[Ron Rosenfeld]

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