leave the decimal fraction

How do I remove the integer from a number and retain the decimal fraction
portion (123.45 would yield 0.45)

A1=123.45

in B1 put:

=MOD(A1,1)

HTH

"Darrel" wrote:

> How do I remove the integer from a number and retain the decimal fraction
> portion (123.45 would yield 0.45)

=MOD(A1,1)

HTH
--
AP

"Darrel" <[email protected]> a écrit dans le message de news:
[email protected]...
> How do I remove the integer from a number and retain the decimal fraction
> portion (123.45 would yield 0.45)

If you're happy with it in a different cell I'd do this:

=a1-int(a1)

(where a1 contains the original number)

"Darrel" wrote:

> How do I remove the integer from a number and retain the decimal fraction
> portion (123.45 would yield 0.45)