How to combine text and a number without losing formatting in Excel

Q: How do I show the number in thousands, like $1,250K?

A comma at the end of the format divides by 1,000: =TEXT(B2,"$#,##0,")&"K".

Formula (Excel and Google Sheets)

=A2&" sales: "&TEXT(B2,"$#,##0")&" ("&TEXT(C2,"+0.0%;-0.0%")&")"

Wrap the number in TEXT with the format you want: =A2&" sales: "&TEXT(B2,"$#,##0"). The & operator alone drops currency signs, commas and percent signs.

Result on the example: one result per row in D2, filled down to D5
Works in: Every current version
Google Sheets: Same formula

See it work

The formula is already in D2, filled down to D5. Change any input and the result updates, or edit the formula to experiment.

How it works

Cell formatting is only on screen; joining with & uses the stored value, 1250430.5. TEXT applies a format inside the formula: "$#,##0" adds the dollar sign and commas and rounds to whole dollars, and "+0.0%;-0.0%" multiplies by 100, keeps one decimal and shows a sign for both positive and negative values (the part after the semicolon is for negatives).

=A2&" sales: "&TEXT(B2,"$#,##0")&" ("&TEXT(C2,"+0.0%;-0.0%")&")"

Result"East sales: $1,250,431 (+8.4%)"

A2"East"
The value in A2.
A2&" sales: ""East sales: "
The & operator joins as text.
B2$1,250,430.50
The value in B2.
TEXT(B2,"$#,##0")"$1,250,431"
TEXT: Formats a number or date as text, e.g. "mmm" or "$#,##0".
- valueB2$1,250,430.50
- format_text"$#,##0"
A2&" sales: "&TEXT(B2,"$#,##0")"East sales: $1,250,431"
The & operator joins as text.
A2&" sales: "&TEXT(B2,"$#,##0")&" (""East sales: $1,250,431 ("
The & operator joins as text.
C28.4%
The value in C2.
TEXT(C2,"+0.0%;-0.0%")"+8.4%"
TEXT: Formats a number or date as text, e.g. "mmm" or "$#,##0".
- valueC28.4%
- format_text"+0.0%;-0.0%"
A2&" sales: "&TEXT(B2,"$#,##0")&" ("&TEXT(C2,"+0.0%;-0.0%")"East sales: $1,250,431 (+8.4%"
The & operator joins as text.
A2&" sales: "&TEXT(B2,"$#,##0")&" ("&TEXT(C2,"+0.0%;-0.0%")&")""East sales: $1,250,431 (+8.4%)"
The & operator joins as text.

In Google Sheets

The same formula works in Google Sheets: =A2&" sales: "&TEXT(B2,"$#,##0")&" ("&TEXT(C2,"+0.0%;-0.0%")&")". We ran it in Google Sheets mode on the same data and it returns the same results.

Other ways to do it

Each one was run on the same example sheet.

Formula	Result	When to use it
=A2&" sales: "&B2&" ("&C2&")"	East sales: 1250430.5 (0.084), West sales: 982115 (-0.031), North sales: 1504220.75 (0.127)…Different result	Plain joining, to see the problem. "East sales: 1250430.5 (0.084)": the formatting is gone.

Common mistakes

TEXT returns text, so the summary column can't be summed. Keep the numbers in their own columns.
Format codes follow your spreadsheet's language and separators. A European Excel may need "# ##0 €".

Try it yourself

Same data, empty answer cell. Your formula is graded instantly, then re-checked on changed data, so a typed-in number won't pass.

Combine text and a number without losing formatting

In D2, write a summary like "East sales: $1,250,431 (+8.4%)", with the sales rounded to whole dollars and the growth as a signed percentage. Fill down to D5.

Questions

How do I show the number in thousands, like $1,250K?

A comma at the end of the format divides by 1,000: =TEXT(B2,"$#,##0,")&"K".

How do I keep two decimals?

Use TEXT(B2,"$#,##0.00").

Checked by running on 2026-10-30: every formula and result on this page was calculated by the Spreadsheet Practice formula engine, in both Excel and Google Sheets modes.