Making Values Permanent

[Guest]

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

 

[Guest]

Use copy - paste special - paste value

Mike

 

[Don Guillett]

copy
paste VALUES

 

[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