Making Values Permanent

E

Efrain

I have columns that have many columns with values that are calculated. I
would like to make these calculated values permanent.

i.e. Column AA is a calculated from 3 other columns. I want Column AA just
to be calculated value and not the formula anymore.

When I try to just copy and paste, it copies the formula, which I do not want.

Thanks!

Efrain
 
P

Paul B

Efrain, copy, paste special, values
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Top