Jun 22 2021 07:32 PM
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.
Jun 22 2021 09:14 PM
@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."