We encounter this problem of numbers behaving as text with commas when we import data from some other software in to excel sheet.
There are times when you bring data from other software to excel sheets and find that some of the numbers are formatted as text