Is there a way to save the result of a formula in place of the actual formula?

I have a large workbook with many worksheets. Each of these sheets have simple "=" formulas to set each cell equal to a number from one huge master list which is in a separate worksheet. Now I want to replace each "=" formula with the actual value from the master list without manually entering it. Is there a way to do this?

thanks..............................matt

Hello Matt

While you are waiting on someone mor knowledgable than me you might try this sight...

Excel Topics: Formulas/Functions (By Category)

Thanks for the link.

I did figure it out. To replace a cell formula with the value, select the cell, click copy on the Standard toolbar, click the arrow next to the Paste button on the Standard toolbar and select Value. The cell formula gets replaced with the result of calculating the formula.

Matt

Cool Bluesmatt

Thanks for posting how you solved the question. Marked as Resolved.

Chris