Fixing formulas in Excel
![](http://www.projectwoman.com/uploaded_images/values-769669.jpg)
Sometimes you need to convert formulas into fixed figures - not often I admit, but often enough that there is an Excel tool for doing this.
To convert any formula into a fixed value, select the cell or cells to fix and choose Edit > Copy and then immediately choose Edit > Paste Special > Values. Instantly your formulas are converted to fixed figures.
Labels: Excel 2003, paste special, values
![Add to Technorati Favorites](http://static.technorati.com/pix/fave/btn-fave2.png)
<< Home