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. LO Calc , 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 LibreOffice Calc .