ASAP Utilities, description of our Excel tools

English (us) / Nederlands / Deutsch / Español / Français / Português do Brasil / Italiano / Русский / 中文(简体) / 日本語

Numbers & Dates » 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.

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

Starting this utility

In the Excel menu choose: ASAP Utilities » Numbers & Dates » Change values to text values (adding ' in front)

« Return to the list of “Numbers & Dates” tools.

« Previous
Convert unrecognized numbers (text?) to numbers

Next »
Fill cells with their formatted value

You can do this too

Download "The one essential add-in for all Excel users."

Additional keywords for this tool:
textnumbers

Printer friendly page

Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at: