logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

Insert Leading Apostrophe to Store Numbers as Text

ASAP Utilities  › Numbers & Dates  ›  4. 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


Numbers & Dates  ›  4 Insert Leading Apostrophe to Store Numbers as Text
Additional keywords for this tool:
Convert numbers to text, Store numbers as text, Add apostrophe to numbers, Insert apostrophe in front of number, Treat number as text, Textnumbers, Convert numeric values to text, Format number as text with apostrophe, Apostrophe before number, Convert cell to text with apostrophe, Store product codes as text in Excel

Choose your language preference below

English (us)NederlandsDeutschEspañolFrançaisPortuguês do BrasilItalianoРусский中文(简体)日本語

Download
Convert Numbers Stored as Text to Real Numbers




Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.