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?
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.