Skip to main content

How to Use the VALUETOTEXT Function in Excel for Mac

Joshua earned an MBA from USF and he writes mostly about software and technology.

The Purpose of the VALUETOTEXT Function

The VALUETOTEXT function gives an Excel user the ability to change any value in a cell to a text value. For instance, you may need a numeric value to appear in a text format to avoid formatting issues.

VALUETOTEXT Function

The VALUETOTEXT function gives an Excel user the ability to change any value in a cell to a text value.

The VALUETOTEXT function gives an Excel user the ability to change any value in a cell to a text value.

The VALUETOTEXT Function Syntax

The VALUETOTEXT function needs to be inputted into a cell like a formula for it work. To manually add this function, the following steps need to be taken:

  1. A cell needs clicked type "=VALUETOTEXT(".
  2. After the open parenthesis
  3. Next, include the type of format. 0 for concise or 1 for strict.
  4. Lastly, add a closed parenthesis followed by entering the formula.

Below in bold the syntax of the VALUETOTEXT function is shown in its entirety. This is followed by detailed definitions of each argument in the formula.

=VALUETOTEXT(Value, [Format])

Value - This is the cell that contains the value that is to be converted to text.

Format - Concise 0 or strict 1 is chosen. When the strict format is chosen text may be converted to show escape characters and row delimiters.

Examples

In the first example below, only one argument is used to covert a numeric value to a text value. A '1' could be added to the format argument but unnecessary.

In the second example, an already existing text value is used with a '2' as the format argument. The result shows escape characters (or quotes) outside of the text.

how-to-use-the-valuetotext-function-in-excel-for-mac

Inserting the VALUETOTEXT Function

The VALUETOTEXT function can be inserted in a cell to make the functional arguments more clear. To use this method you need to first select the cell where you need you result to appear. Next, click on the formulas tab and select the Text button. Choose VALUETOTEXT from the list of functions.

Scroll to Continue
how-to-use-the-valuetotext-function-in-excel-for-mac

After the formula builder has appeared, you can start adding arguments. When new values are added to these argument field, the results are displayed at the bottom of the formula builder.

Also, notice the tips that are given within that sidebar. To print the results into the cell, click Done.

how-to-use-the-valuetotext-function-in-excel-for-mac

References

Microsoft. (n.d.). VALUETOTEXT function. Retrieved July 20, 2022, from https://support.microsoft.com/en-us/office/valuetotext-function-5fff61a2-301a-4ab2-9ffa-0a5242a08fea

How to Use the COUNT Function in Excel

How to Use the AVERAGE Function in Excel

How to Use the ABS Function in Excel

How to Remove Errors in Excel With the IFERROR Function

How to Use the VLOOKUP Function in Excel

Converting Measurement Units: Using the CONVERT Function

To learn more about using functions in Excel I recommend The Excel 2019 Bible book. I have been using the Excel Bible for years to improve my understanding of all aspects of this Microsoft product.

This content is accurate and true to the best of the author’s knowledge and is not meant to substitute for formal and individualized advice from a qualified professional.

© 2022 Joshua Crowder

Related Articles