Can't Group and Numbers not in Order

Hi,

Desperately trying to analyse a baseline report for my organisation.

On my computer it's showing all the numbers with a green tag saying the numbers have been recorded as text. This isn't happening to my colleague's version.

I have followed the Word help guide and tried to 'text to columns', I have tried copying a blank cell and adding the value, I have also tried highlighting and formatting all cells to numbers. Nothing seems to solve it and it's preventing me from grouping age/income/all the fiddly stuff.

I'm trying to do it manually with filters, which is taking forever, especially as when I try to list the numbers in order (A-Z) it's listing 10,000, 10,500, 11,000 but then further down' I'm seeing 3,000 listed above 30,000 rather than after 2,000.

I'm about to set fire to my computer.

Please help.

Windows 10
Office 365
Excel

Any chance you can attach your spreadsheet?

Can I send it privately? It's not entirely anonymised and sensitive subject matter.