How to Limit Decimal Places in an Excel TEXTJOIN Result
Question details
The user needs to control or limit the number of decimal places when combining numbers using the TEXTJOIN function.

- 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.
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.
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.
Select the cell containing your current TEXTJOIN formula to edit it in the Formula Bar.
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").
If you need strict mathematical rounding rather than just display formatting, wrap the value in ROUND first: TEXT(ROUND(A1, 2), "0.00").
Press Enter. The resulting text string will now display the combined numbers with exactly two decimal places.

Convert to a Number Using the VALUE Function
If your TEXTJOIN formula returns only a single numeric value without any text delimiters like commas, you can convert it back to a standard number.
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. Open your workbook in WPS Spreadsheet: Launch WPS Office and open your existing spreadsheet file.
- 2. Enter the nested formula: Select your target cell and input your nested TEXTJOIN and TEXT formula into the formula bar.
- 3. Press Enter to execute: Hit Enter to instantly calculate and display the perfectly formatted text string with your desired decimal limits.

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.




