Tuesday, August 21, 2012

How to Convert Excel Formulas to Hard Numbers


1. Highlight the cell(s) with that contain formulas you wish to convert to hard numbers.
2. Right click your mouse and select 'Copy'.
3. Right click again and select 'Paste Special'.
4. Select the 'Values' option in the Paste section of the Paste Special box.
5. Click 'OK.'
6. Hit the Enter key. The cell(s) selected will now display numbers rather than formulas.

Blogger news