logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel 365, 2021, 2019, 2016, 2013, 2010 or 2007 with ASAP Utilities in its menu

Change values to text values (adding ' in front)

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

Numbers & Dates  ›  4. Change values to text values (adding ' in front)

This utility changes all numbers in the selected cells to text values.
This is done by placing an apostrophe (') in front of each value.
Cells with formulas that have a numeric result will be filled with their calculated values. Cells with text or a date are skipped.

If you want to spell out numbers you can use the utility "Spell numbers or amounts (EN, DE, FR, NL)".

Starting this tool

Additional keywords for this tool:
Convert unrecognized numbers (text?) to numbers

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