Change from a sum reference to the number
 

Hi,
I have numbers on one worksheet that are the sum of other
numbers....e.g. the contents of the cell are =sum(a3:e3)
I'd like to copy that cell to another worksheet, but I want the
number, not the =sum(a3:e3).
Can you give some advice?
Thanks
chuckm

Change from a sum reference to the number
 

Chuck, copy the cell then edit 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 97 & 2000
** remove news from my email address to reply by email **

"ChuckM" wrote in message
m...
Hi,
I have numbers on one worksheet that are the sum of other
numbers....e.g. the contents of the cell are =sum(a3:e3)
I'd like to copy that cell to another worksheet, but I want the
number, not the =sum(a3:e3).
Can you give some advice?
Thanks
chuckm

Change from a sum reference to the number
 

When you paste, use paste special then pick the "values"
option.

-----Original Message-----
Hi,
I have numbers on one worksheet that are the sum of other
numbers....e.g. the contents of the cell are =sum(a3:e3)
I'd like to copy that cell to another worksheet, but I
want the
number, not the =sum(a3:e3).
Can you give some advice?
Thanks
chuckm
.