leave the decimal fraction

D

Darrel

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

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top