software

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?

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.

quot;derek_m_taylorquot; gt; wrote in message
...
gt; The worksheet I am working on is actually used to input required data into
gt; another worksheet. I don't want to just simply copy and paste the cells
gt; that
gt; are needed because they contain a formula. Is there a way to format the
gt; cells so the total is displayed vice the formula?
I figured it out shortly after I posted, all I did was right click and select
paste special, choosing show value under the options.

quot;Richard O. Nevillequot; wrote:

gt; In Tools-Options View tab, there is a checkbox for formulas. You can create
gt; a copy of the sheet you are working on, and check this box to show the
gt; formulas, or clear it to show values.
gt;
gt; quot;derek_m_taylorquot; gt; wrote in message
gt; ...
gt; gt; The worksheet I am working on is actually used to input required data into
gt; gt; another worksheet. I don't want to just simply copy and paste the cells
gt; gt; that
gt; gt; are needed because they contain a formula. Is there a way to format the
gt; gt; cells so the total is displayed vice the formula?
gt;
gt;
gt;