Saturday, July 2, 2011

Turn Off Error Checking For Number

With error checking turned on in Excel, you see a small green triangle if you enter a number into a cell that has text formatting applied to it. If you don’t want to see these error indicators, you can turn them off.

To Turn off error checking for Number formatted as text:
  • Click the File tab.
  • Under Help, click Options.
  • In the Excel Options dialog box, click the Formulas category.
  • Under Error checking rules, clear the Numbers formatted as text or preceded by an apostrophe check box.
  • Click OK.


Post a Comment

Search This Blog


Related Posts Plugin for WordPress, Blogger...
Twitter Delicious Facebook Digg Stumbleupon Favorites More