leave the decimal fraction

[Darrel]

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

 

[Ardus Petus]

=MOD(A1,1)

HTH

 

[Toppers]

A1=123.45

in B1 put:

=MOD(A1,1)

HTH

 

[Josh Craig]

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

=a1-int(a1)

(where a1 contains the original number)