converting formulas to numbers?

G

Grouge

I have a column that uses the simple SUM formula. I then need to cop
those results onto another sheet. Of course when I do this all I ge
is the error message because it is still trying to execute the formula
Is there a way I can convert the formula results into numbers
 
P

Paul B

Grouge, copy the cells and paste special valves
--
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
 
N

Niek Otten

Paste Special, check Values

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
| I have a column that uses the simple SUM formula. I then need to copy
| those results onto another sheet. Of course when I do this all I get
| is the error message because it is still trying to execute the formula.
| Is there a way I can convert the formula results into numbers?
|
|
| --
| Grouge
| ------------------------------------------------------------------------
| Grouge's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36445
| View this thread: http://www.excelforum.com/showthread.php?threadid=567873
|
 
Top