View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve[_53_] Steve[_53_] is offline
external usenet poster
 
Posts: 4
Default 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
.