Change value to text (adding ' in front)

Number > Change values to text values (adding ' in front)

This utility replaces numbers in selected cells with text values.

To do this, an apostrophe (') is placed before each value.

Cells with formulas that have a numeric result will be filled with their calculated values. Cells with text are skipped.

Screenshot

After application:

Running this tool

Click YLC Utilities > Number > Change values to text values (adding ' in front) :

How much time will this save?

Using this tool will definitely save you time and effort. However, the actual time savings will depend on how often you use it. Excel , the amount of data you work with, and how often you use the tool.

Download the extension

You can use the utility Change values to text values (adding ' in front) by installing the extension YLC Utilities .

After that, this function will be available in all files that are opened in Excel .