How to Concatenate Decimal Places in Excel (5 Examples)

Example 1 – Concatenate with Two Decimal Places

Steps:

Enter the following formula in cell D5.

=CONCATENATE("The Unit price of the ",B5," is ","$",ROUND(C5,2))

Concatenate with Two Decimal Places

Formula Breakdown

CONCATENATE(“The Unit price of the “,B5,”is “,”$”,ROUND(C5,2)): This function will concatenate or join the text mentioned in the first argument, proceeded with combining the text mentioned in the cell B5 with the decimal number mentioned in cell C5 in the last argument.

Drag the Fill Handle to cell D7.
The range of cell D5:D7 will fill with concatenated fruit names and prices including the decimal.

Example 2 – Concatenate Without Losing Decimal Places

Using the TEXT function, we can fix decimal numbers rounding limit. We will concatenate them using an ampersand sign. There will be no loss of decimal places in this procedure.

Steps

Enter the following formula in cell D5.

="The Unit price of the "&B5&" is "&"$"&TEXT(C5,"0.000")

Concatenate Without Losing Decimal Places

Drag the Fill Handle to cell D7.
The range of cell D5:D7 will fill with concatenated fruit names and prices including the decimal.

Example 3 – Concatenating with TEXT Function

Steps

Enter the following formula in cell D5.

="The Unit price of the "&B5&" is "&"$"&TEXT(C5,"0.00")

Concatenating with TEXT Function

Drag the Fill Handle to cell D7.
The range of cell D5:D7 will fill with concatenated fruit names and prices including the decimal.

Example 4 – Using ROUND Function

Steps

Select cell D5 and enter the following formula.

="The Unit price of the "&B5&" is "&"$"& ROUND(C5,2)

Using ROUND Function to Concatenate Decimal Places in Excel

Drag the Fill Handle to cell D7.
The range of cell D5:D7 will fill with concatenated fruit names and prices including the decimal.

Example 5 – Combining CONCATENATE and FIXED Functions

Steps

Select cell D5 and enter the following formula.

=CONCATENATE("The Unit price of the ",B5,"is ","$",FIXED(C5,2))

Combining CONCATENATE and FIXED Functions to Concatenate Decimal Places in Excel

Formula Breakdown

FIXED(C5,2): This FIXED function will fix the rounding of the number mentioned in the first argument. The rounding of the numbers depends upon the second argument.
CONCATENATE(“The Unit price of the “,B5,”is “,”$”,FIXED(C5,2)): This function will concatenate or join the text mentioned in the first argument, proceeded with joining the decimal number mentioned in the second argument.

Drag the Fill Handle to cell D7.
The range of cell D5:D7 will fill with concatenated fruit names and prices including the decimal.