Formatting Cell To Display Value Instead Of Formula

G

Guest

The worksheet I am working on is actually used to input required data into
another worksheet. I don't want to just simply copy and paste the cells that
are needed because they contain a formula. Is there a way to format the
cells so the total is displayed vice the formula?
 
R

Richard O. Neville

In Tools-Options View tab, there is a checkbox for formulas. You can create
a copy of the sheet you are working on, and check this box to show the
formulas, or clear it to show values.
 
G

Guest

I figured it out shortly after I posted, all I did was right click and select
paste special, choosing show value under the options.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top