Sign up ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a spreadsheet where a certain column has a lot of data which generates "number stored as text" errors. I want the numbers to be stored as text in this column for certain formatting purposes. Is there a way for me to quickly dismiss all these errors at once, or tell Excel to ignore this error for the entire row as a rule, without entirely disabling the error for the whole sheet or program?

share|improve this question
There is no way to deactivate error checking only for a certain column. You have to deactive number stored as column in general or to ignore the error indicator. – nixda Dec 31 '12 at 6:21
there is a way to de-activate check in cell, and this is persisted in XLSX but not in XLS though – Arioch 'The Mar 5 '13 at 12:28

4 Answers 4

  1. Select the top-left first cell in the sheet that has the green triangle indicating the error
  2. Scroll to the last bottom-right cell that has the error. Hold Shift and select that last cell
  3. Go back to that first cell, there will be a clickable icon to do something about the error
  4. Click on it and then click "Ignore Error"

This will ignore all the errors in the selection you have. But you must start with the first error to get the pop-up to ignore them.

share|improve this answer
I had a dog and his name was... BINGO! – Scott Beeson Apr 24 '13 at 23:41
Thank you effusively! – LePressentiment Oct 13 '14 at 13:53
another tip, while in that cell, you can press Ctrl+Shift+Down arrow, then you will select all sells until the last cell with a value :) – chrispepper1989 Oct 13 at 15:00

If you want it to apply to the whole work book (that is what I need for special work books) I use File>Options>Error Checking> uncheck the "Enable Background Error Checking" box. Save.

Excel 2010

share|improve this answer

In Excel, I believe you can fix the problem by selecting the entire column and selecting a format change.

share|improve this answer
Changing format only does nothing at first glance. You also have to re-enter all values or use the text in columns option. But in this moment all binary values will lose their leading zeros. And thats what the OP wants to avoid. Unfortunately thats not a solution. – nixda Dec 31 '12 at 6:16

Uncheck this option:

File > Options > Formulas > Error Checking Rules > Numbers formatted as text or preceded by an apostrophe

share|improve this answer
I want to ignore multiple without ignoring globally. This is specifically mentioned in the question. – Iszi Oct 21 at 16:45
Select the entire column or contiguous columns; go back to top of columns while keeping selection and select "igore error" from displayed error box. – dbsdba Oct 26 at 10:59

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.