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...
Excel Data Validation - Limit What a User Can Enter into a Cell
Tutorial: Data Validation is a tool in Excel that you can use to limit what a user can enter into a...
VBA IF Statement in Excel Macros
Tutorial: IF statements allow you to make decisions in your Macros and VBA in Excel. An IF statement...

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.