TOP

Change value to text (adding ' in front)

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

This utility replaces numbers in selected cells with text values.

For this, each value is preceded by an apostrophe (').

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

If you want to write numbers in words, you can use the utility: Write a number or amount in writing .

Screenshot

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

After application:

Launch this tool

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

Number and Date › Change value to text (adding ' in front)

How much time will it save?

Using this tool, you are guaranteed to save time and effort. However, the actual time savings depends on how often you use LibreOffice Calc, the amount of data you work with, and how often you use the tool.

Download

If you don't already have YLC Utilities, you can download the free version "YouLibreCalc.oxt" or the full-featured version "YLC_Utilities.oxt" .

Additional keywords for this tool:
convert number to text, convert to text, number as text