Formatting Numbers within a Text Column

[svd44]

Hi there! I have a column that has both text and numbers. 

I need to format the numbers within the column to include a comma, but since the column also has text, it's not allowing me to apply a format to the cells that have numbers featured since the entire column has been data typed as text due to the "not available" text. 

Thanks so much!  

[ExcelMonke · Accepted solution]

Consider the following measure/column: 

FormattedPop = 
IF(Table[Population NA] = "Not Available","Not Available",FORMAT(Table[Population NA],"General Number"))

 You for the "General Number" part, you can tweak it to your requirements.
Take a look here for format options: https://learn.microsoft.com/en-us/dax/format-function-dax