logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel 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.

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

Starting this tool


Numbers & Dates  ›  4 Change values to text values (adding ' in front)
Additional keywords for this tool:
textnumbers
Convert unrecognized numbers (text?) to numbers



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


Empowering Excel Users Worldwide for 25 Years