Making Values Permanent
 

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

Making Values Permanent
 

Use copy - paste special - paste value

Mike

"Efrain" wrote:

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

Making Values Permanent
 

copy
paste VALUES

--
Don Guillett
SalesAid Software

"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

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