Digits to the right of decimal point

  • Thread starter Thread starter Tigerxxx
  • Start date Start date
T

Tigerxxx

Hello,

What forumla should I use to get the digits to the right side of the decimal?
i.e. if the number is 94.203, then I want to get the "203".

Thank you
 
You can use the following MOD function to return the remainder after dividing
the value by 1. The example assumes that the value to be divided is in cell
A1, change formula based upon your layout:

=MOD(A1,1)
 
Thank you Kevin!

Kevin B said:
You can use the following MOD function to return the remainder after dividing
the value by 1. The example assumes that the value to be divided is in cell
A1, change formula based upon your layout:

=MOD(A1,1)
Click to expand...
 
On the other hand, if you always have 3 digits to the right of the decimal
you could use =RIGHT(A1,3).

If there aren't fixed decimals, the following would work:

=RIGHT(A1,LEN(A1)-(FIND(".",A1,1)))
 

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

Excel Extract Text from decimal separated string 6
Formula to identify decimal versus whole numbers 12
Getting numbers on the right side of the decimal point 5
Sum Function 2
Decimal point in bar chart and similar 1
how to place a decimal after 3rd digit 6
How to change default value of comma style 1
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1

Back
Top