I'm using Excel 2010, and have a spreadsheet of simple numbers (they're 1-5 ratings for a range of questions), so I have questions across the top, and each person's responses as a separate row. The numbers are whole numbers, but each cell has an error checking marker saying 'Number Stored as Text'. So I highlighted all the cells, set cell format to 'Number' with 0 decimal places, and it doesn't do anything.
I'm quite competent with Excel, but am I missing something really stupid here?
The file is in Compatibility Mode, stored as .xls (through necessity I'm afraid)