Function Problems

How to Limit Decimal Places in an Excel TEXTJOIN Result

Huda QurayshiHuda Qurayshi Oct 9, 2026 871 views

Question details

The user needs to control or limit the number of decimal places when combining numbers using the TEXTJOIN function.

How to Limit Decimal Places in an Excel TEXTJOIN Result
Product
Spreadsheet
Device & OS
not provided
Scenario
Combining multiple numeric values into a single text string using the TEXTJOIN formula.
Observed behavior
The joined result is treated as a text string, which prevents standard numeric cell formatting (like decreasing decimal places) from being applied to the combined values.
Before you start

Identify the specific numeric cells you are joining and decide the exact number of decimal places you want to display for each value in the final string.

Solution 1Recommended

Format Numbers Before Joining Using the TEXT Function

The most reliable method is to format the numeric values as text with specific decimal limits before they are combined by TEXTJOIN.

Because TEXTJOIN outputs a text string, any numbers inside it lose their underlying numeric formatting capabilities. To fix this, you must apply the desired decimal formatting at the formula level before the text is joined.

1
Locate your TEXTJOIN formula

Select the cell containing your current TEXTJOIN formula to edit it in the Formula Bar.

2
Wrap cell references in the TEXT function

Inside the TEXTJOIN formula, modify the numeric cell references by wrapping them in the TEXT function. For example, change A1 to TEXT(A1, "0.00").

3
Use ROUND for exact rounding

If you need strict mathematical rounding rather than just display formatting, wrap the value in ROUND first: TEXT(ROUND(A1, 2), "0.00").

4
Apply and execute

Press Enter. The resulting text string will now display the combined numbers with exactly two decimal places.

Format Numbers Before Joining Using the TEXT Function
Custom Formats: You can change "0.00" to any valid custom number format string depending on your needs, such as "0.0" for one decimal place or "0" for whole numbers.
Advanced Formula Editor

Easily Manage Advanced Formulas in WPS Spreadsheet

WPS Spreadsheet fully supports advanced array functions and text manipulation tools like TEXTJOIN, TEXT, and ROUND, allowing you to format complex data seamlessly.

  1. 1. Open your workbook in WPS Spreadsheet: Launch WPS Office and open your existing spreadsheet file.
  2. 2. Enter the nested formula: Select your target cell and input your nested TEXTJOIN and TEXT formula into the formula bar.
  3. 3. Press Enter to execute: Hit Enter to instantly calculate and display the perfectly formatted text string with your desired decimal limits.
100% compatible with Microsoft Excel formulas and .xlsx filesSupports all advanced text manipulation and array functionsClean and intuitive interface for editing complex nested formulas
microsoft office alternative - wps office

Frequently Asked Questions

Why does standard number formatting not work on a TEXTJOIN result?

TEXTJOIN outputs a text string, even if the joined contents are exclusively numbers. Standard Excel cell formatting only applies to true numeric or date values, so any attempt to use the 'Decrease Decimal' formatting on a text string will be ignored.

Can I apply different decimal formats to different numbers in the same TEXTJOIN formula?

Yes. Instead of applying a single format to a range, you can manually join individual cell references and wrap each one in its own TEXT function with specific formatting before they are processed by TEXTJOIN.

What happens if I wrap a comma-separated TEXTJOIN result in the VALUE function?

It will return a #VALUE! error. Excel cannot recognize a text string that contains commas (acting as separators) as a single valid number, so the VALUE function fails to convert it.