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
Thanks in advance
PJ
Thanks in advance
PJ
Staffing Master Form.xls | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
8 | PreK | 200 | 11.11 | 1111111111111 | |||||||
9 | K-1 | 43 | 1.72 | 72 | |||||||
10 | Grades2-3 | 198 | 7.07 | 07142857142857 | |||||||
11 | Grades4-6 | 54 | 1.93 | 92857142857143 | |||||||
12 | Grades7-8 | 12 | 0.43 | 428571428571429 | |||||||
Sheet3 |