Try this:

Select the range to be impacted

From the Excel main menu:
<edit<copy
<edit<paste special......check: Values........Press: OK

That will replace all formulas with their calculated values.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Omer" wrote:

Hi everybody

I have completed my workbook by entering different formulas in different
cells, Now, I want all cells to freeze the value they have, I dont care if
these cells just forget the formula and now retain only the numeric value
they have calculated, is their any way to do that.

Thanks all