Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

tom s
Lv 4
tom s asked in Computers & InternetSoftware · 7 years ago

Excell: rip numbers out?

I am doing some math in an Excell sheet.

There are several cells with equations inside like

=C37+D37+E37

=A1*B1

Now I want to copy and paste resultant numbers into another Excell sheet and a Word sheet, but instead of copying the actual resultant numbers they copy the equations inside.

Is there a way to modify a cell (or group of cells) so that they lose the equations inside them but retain their resultant number values?

Or

is there some special way to copy a cell (or group of cells) so that it copies the resultant number values instead of the equation inside?

Thank you.

1 Answer

Relevance
  • Anonymous
    7 years ago
    Favorite Answer

    Go to Paste Special and then select Values.

Still have questions? Get your answers by asking now.