Forum Discussion

ashcr1300's avatar
ashcr1300
Copper Contributor
Jun 15, 2021
Solved

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's avatar
    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")

Resources