You are here KNOWLEDGE Excel Tips Excel Text, Editing and Format Format number in joining text with linked number in Microsoft Excel

Query, Share and Manage Excel workbooks on LAN, Internet

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
Format number in joining text with linked number in Microsoft Excel