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 ca...
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."