Tip of the Day | Thursday January 22nd, 2026
Discover new tools to get things done.
Insert Leading Apostrophe to Store Numbers as Text
This tool inserts a leading apostrophe (') in front of each number in your selected cells so that Excel stores and treats them as text values. It helps ensure consistency in your data and standardize data formats when working with mixed data types, such as a column with product codes that have both numbers and text values. Cells containing formulas that yield numeric results are replaced with their static values, which are stored as text. Cells that contain text or dates are not affected.Starting this tool
- Click ASAP Utilities › Numbers & Dates › 4. Insert Leading Apostrophe to Store Numbers as Text
- Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...
Choose your language preference below
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語
©1999-2026 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.