Missing comma when sentence joint cell data.

Copper Contributor

I've create sentence with combination data call from cell. The problem is, original cell was in number format with thousand comma separator (,). when the sentence i created success the data that i call using formula copy cell didn't show the thousand comma separator. Anyone can solved my problem?

 

Example

Cell C3 value = 6,591.56

Cell C5 Value= 2,670.04

Cell C6="For ISP link, the maximum utilization is around "&(C3)&"Mbps ("&(I18)&"%) for Inbound and "&C5&"Mbps ("&(K18)&"%) for outbound."

 

The result became like this, the comma was removed. how to maintain the comma?

Result Cell C6

For ISP link, the maximum utilization is around 6591.56Mbps (82.39%) for Inbound and 2670.04Mbps (33.38%) for outbound.

1 Reply

@abdulbasithamdy Try it this way, using TEXT to set consistent formatting of numbers inside a concatenated text string.

="For ISP link, the maximum utilization is around "&TEXT(C3,"#,##0.00")&" Mbps ("&TEXT(I18,"0.00")&"%) for Inbound and "&TEXT(C5,"#,##0.00")&" Mbps ("&TEXT(K18,"0.00")&"%) for outbound."