The ASAP Utilities menu in Excel (English)
Insert an apostrophe (') in front of each formula in the selected cells
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語Formulas › 9. Insert an apostrophe (') in front of each formula in the selected cells
This tool inserts an apostrophe (') in front of each formula in the selected cells, which turns them to text.Note:
To turn the changed formulas to actual calculating formulas again, you can use the following tool from ASAP Utilities:
"Numbers & Dates » Change not recognized numbers (text?) to numbers"
Starting this tool
- Click ASAP Utilities › Formulas › 9. Insert an apostrophe (') in front of each formula in the selected cells
- Specify a Keyboard Shortcut: ASAP Utilities › Favorites & Shortcut keys › Edit your favorite tools and shortcut keys...
