Forum Discussion
Missing comma when sentence joint cell data.
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."
