Hi Rob,

I understand that you're having trouble removing multiple errors in Excel error checking. I'm happy to help you with that!

To convert all the cells in a column from text to numbers, you can use the following steps:

1. Select the column that contains the numbers stored as text.
2. Click on the 'Data' tab in the ribbon.
3. Click on the 'Text to Columns' button.
4. In the 'Convert Text to Columns Wizard', select 'Delimited' and click 'Next'.
5. Uncheck all the delimiter options and click 'Next'.
6. In the 'Column data format' section, select 'General' and click 'Finish'.

This should convert all the cells in the selected column from text to numbers.

If you want to ignore the error for all the cells in the column, you can use the following steps:

1. Select the column that contains the errors.
2. Click on the 'File' tab in the ribbon.
3. Click on 'Options'.
4. Click on 'Formulas' in the left-hand menu.
5. Under 'Error Checking Rules', uncheck the box next to 'Numbers formatted as text or preceded by an apostrophe'.
6. Click 'OK'.

This should ignore the error for all the cells in the selected column.