SOLVED

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

Copper Contributor

ashcr1300_0-1623718384860.png

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"

2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@ashcr1300 

> Right click the cell

> click Format Cells...

> Select this options and Click OK

StoneKiwi_0-1623725589820.png

 

Or to reference the cell and have it display text then

=TEXT(cell,"##,#0")

@StoneKiwi Thank you so much! I entered =TEXT(cell,"##,#0") in my formula and it worked. 

1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@ashcr1300 

> Right click the cell

> click Format Cells...

> Select this options and Click OK

StoneKiwi_0-1623725589820.png

 

Or to reference the cell and have it display text then

=TEXT(cell,"##,#0")

View solution in original post