Change values to text values (adding ' in front)

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 tool

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

Additional keywords for this tool:
textnumbers

Convert unrecognized numbers (text?) to numbers

Fill cells with their formatted value

Download