» Format number in joining text with linked number in Microsoft Excel

Example: Format a number without decimal places, with a thousands separator, and combine it with text.

1. In cell A1, enter the text "You still owe the sum of".
   
2. In cell A2, enter the number - 5434.
   
3. In cell A3, enter the text "for invoice # 2232 from 6/15/2001".
   
4. In cell A4, enter the formula =A1&""&TEXT(A2,"#,##0")&""&A3.
   

Formatting a number with the thousands sign - the letter K
The formula =A1&" "&TEXT(A2,"#,K")&" "&A3

The sentence appearing in the cell - "You still owe the sum of 5K for invoice # 2232 from 6/15/2001".

Screenshot // Format number in joining text with linked number in Microsoft Excel