Jun 14 2021 05:56 PM
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"
Jun 14 2021 07:55 PM
Solution> 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")
Jun 15 2021 10:43 AM
@StoneKiwi Thank you so much! I entered =TEXT(cell,"##,#0") in my formula and it worked.
Jun 14 2021 07:55 PM
Solution> 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")