Excel Forum
Similar Content
Excel VBA - Create an Array - 3 ways
Tutorial: Ill show you three different ways to create an array in Excel VBA and Macros and how to ge...
VBA IF Statement in Excel Macros
Tutorial: IF statements allow you to make decisions in your Macros and VBA in Excel. An IF statement...
Sorting Data by Date, Text, or Number in Excel
Tutorial: Sorting Data can be done with a few quick clicks of the mouse. I have used the same data a...



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.