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?