I frequently wish to replace the formulas in a cell(s) with the values.
Currently this requires several steps. Although I could shorten this by
creating a macro, I would suggest that this is a common operation for many
users and creation of a standard function for this would be valuable. Many
users could not create the required macro.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions