# Decimal problem

#### planetpj

##### Active Member
Can any help me I am trying to copy over the last 2 digits over from cell C8 to D8 the problem is that when I copy the value over I get the remainer I only want to copy over 2 digits from the right. in other words 11.11 I want just .11 or 7.07 I just want .07

PJ
Staffing Master Form.xls
ABCDEFGHI
8PreK20011.111111111111111
9K-1431.7272
Sheet3

### Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

#### bigbob

##### Board Regular
=c2-INT(C2) Does this do what you want?
Big Bob

=MOD(C8,1)

Hello

Alternatively

=A1-TRUNC(A1)

#### Ahampson9658

##### New Member

use the mod formula in d8 : =mod(c8,1)

that will return the decimal remainder of a number

#### ctrlaltdel

##### Board Regular
Try this formula=VALUE("."&RIGHT(ROUND(D8,2),2)). It should work for your needs.

What if C8 is

3

0.8889

-45.567 ?

#### planetpj

##### Active Member
Thank you. That did it

PJ

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,167,943
Messages
5,856,432
Members
431,813
Latest member
seconduser

### 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