Formatting a number so it has a comma in the thousands place

I did all this hard work to get the percentage and number together in my graph, but now I can't figure out how to get a comma in there so it reads 325,451. My formula so far is: =C38&CHAR(10)&" ("&TEXT(D38,"0%")&")"

C38 is the cell that contains the value "325,451"

excel

Formulas and Functions

StoneKiwi
Jun 15, 2021
ashcr1300
> Right click the cell
> click Format Cells...
> Select this options and Click OK

Or to reference the cell and have it display text then
=TEXT(cell,"##,#0")

2 Replies

StoneKiwi
Iron Contributor
Jun 15, 2021
ashcr1300
> Right click the cell
> click Format Cells...
> Select this options and Click OK

Or to reference the cell and have it display text then
=TEXT(cell,"##,#0")
- ashcr1300
  Copper Contributor
  Jun 15, 2021
  StoneKiwi Thank you so much! I entered =TEXT(cell,"##,#0") in my formula and it worked.

Forum Discussion

Formatting a number so it has a comma in the thousands place

2 Replies

Resources