leave the decimal fraction

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
You must log in or register to reply here.

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

Similar Threads

Convert Decimal fractions to binary and vice versa 1
How do you convert a fraction to a decimal with 3 places 3
fractions 3
Extract numerator from fraction 9
Take fraction out of the figure 3
Display a number in feet inches and fractions of and inch 1
convert fractions to decimals 4
Convert decimal to fractions 3

Back
Top