Select only the result of an equation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I select (or copy) only the result of an equation - not the equation
itself?

Example:

=2+4
This cell will show 6 not the equation. I want to copy the "6" not the
"=2+4".

Thanks
 
Copy as usual, go to the destination cell, which may be the same one too,
right click, select Paste Special, tick the Values option, and OK out
 
I beleive you want to copy the cell (CTRL + C) and then Paste Special and
select Values the OK.

Hope thats what your after.

Paul
 
Back
Top