Take the 2-minute tour ×
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

2 Answers 2

  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
1  
I had a dog and his name was... BINGO! –  Scott Beeson Apr 24 '13 at 23:41

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

Your Answer

 
discard

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.