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

"Richard O. Neville" wrote:

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.

"derek_m_taylor" wrote in message
...
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?