bulk convert formula to value

I want to convert an entire page of formulas to values. I can do the cut and past thing but it seams like there would be another way. Even if it's with a macro.

Can anybody help

Try:

Please Login or Register  to view this content.

Change your range as needed.

This is easy to do with a few simple steps:

First highlight the all data that you want to convert. (CTRL-A might do this for you if there are no gaps in your data)

Then click on < copy > (or you could do CTRL-C)

Right click on the selected area and choose Paste Special from the pop-up.

Click against Values, then OK, then press the < Esc > key.

Hope this helps.

Pete