# Extract everything to the right of a decimal as an integer?

#### dpucane

##### New Member
Is there a way have the "decimal" come up with everything to the right of the decimal in "strike" as an integer?
For example, next to "146.5" would be "5", next to "146.33" would be "33", "152.75":"75" and so on. Right now I have
=--RIGHT(DJ11,FIND(".",DJ11)-3)
but I have to change the "3" at the end to "2" whenever there's 2 decimal numbers (.33) as opposed to 1 (.5)

### Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
Try

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

Assuming there will always be a decimal value in the cell.
If the value is a whole number, it will return #VALUE! error.

That could be handled with ISERROR or something.

Something like this

Excel 2010
AB
1146.55
276.7575
3134.556556
Sheet1
Cell Formulas
RangeFormula
B1=RIGHT(A1,LEN(A1)-FIND(".",A1))

=a1-int(a1)

Replies
0
Views
226
Replies
16
Views
880
Replies
1
Views
185
Replies
4
Views
452
Replies
3
Views
109

1,196,057
Messages
6,013,166
Members
441,751
Latest member
336448

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back