Coma Format Not Working

[czkeit]

I have a table of data that is pulled from an external website via API. I am referencing one of the cells in the same workbook but different workpage, the data are all numbers. No matter which format I choose it will not change, for example one cell that I am referencing is 8000000000. I want it to display as 8,000,000,000. Thank you in advance for your help.

 

[Fluff]

It sounds like your numbers are not numbers. In a blank cell enter this formula
=ISNUMBER(A1)
Change A1 to the cell that you want to check.
What does the formula return?

 

[czkeit]

It returns a False

 

[Fluff]

Then it's not a number, try text to columns.
Select the column > Data Tab > Text to Columns > Delimited > Next > clear all the checkboxes > Next > General > Finish

 

[czkeit]

Perfect, thank you so much!

 

[Fluff]

Glad to help & thanks for the feedback