View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Paul B Paul B is offline
external usenet poster
 
Posts: 709
Default Making Values Permanent

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

"Efrain" wrote in message
...
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