Excel Forum

Excel Magic Trick 634: Text to Text or Number to Number Matches for Logical Formulas

Learn how to build Logical Formulas for counting with criteria or Conditional Formatting so that the comparison is between Text and Text or Number and Number. Text to Number comparisons do not yield matches such as 2003 and "2003". Learn how to convert Text to a Number or a Number to Text to over come this problem.

Got a Question? Ask it Here in the Forum.