Forum Discussion
ashcr1300
Jun 15, 2021Copper Contributor
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)&"...
StoneKiwi
Jun 15, 2021Iron Contributor
> 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")