Change values to text values (adding ' in front)

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

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

Click ASAP Utilities › Numbers & Dates › 4. Change values to text values (adding ' in front)
Specify a Keyboard Shortcut: ASAP Utilities › Favorites & Shortcut keys › Edit your favorite tools and shortcut keys...

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

©1999-2024 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

Empowering Excel Users Worldwide for 25 Years