leave the decimal fraction
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)
|