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

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

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

Thank you

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

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

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

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.

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1