Part II: Working with Formulas and Functions
You can also convert a formula to text by adding an apostrophe (‘) in front of the equal sign. Then copy the cell as
usual and paste it to its new location. Remove the apostrophe from the pasted formula, and it will be identical to the
original formula. Don’t forget to remove the apostrophe from the original formula.
Converting formulas to values
In certain scenarios, you may want to use formulas to get to an answer and then convert
those formulas to actual values. For example, if you use the RANDBETWEEN function to cre-
ate a set of random numbers and you don’t want Excel to recalculate those random numbers
each time you press Enter, you can convert the formulas to values. Just follow these steps:
- Select A1:A20.
- Choose Home ➪ Clipboard ➪ Copy (or press Ctrl+C).
- Choose Home ➪ Clipboard ➪ Paste Values (V).
- Press Esc to cancel Copy mode.
