Converting an avg value to a whole number next to the avg as if it were typed in.

[Steve113]

I tried a few formulas without success. Any help would be greatly appreciated.

Thank you

Please see example.

[NeedForExcel]

I dont quite understand anything from the attached workbook. What I understand from your example is you are trying to Paste Values without Formulas.

Copy Range P1:P20, Right Click on R1 >> Paste Special >> Values.

Hope it helps..

Deep

[NeedForExcel]

And as mentioned, If you need a Whole Number, in R1, Type =INT(P1) and copy down till P20. Then Copy R1:R20, Right Click on R1 >> Paste Special >> Values.

[Steve113]

Thank you. Very helpful.