How to compare cells containing Numbers in Excel

This post discusses how to compare cells that have number in Excel.

The approach is converting strings to text, and then comparing it.

Two ways to convert a number to text are proposed:

  • When having an array of only numbers, use function TEXT() to ensure they are converted to text.
  • Another way to convert to text is to add an apostrophe to the beginning of the line (‘).

You might also be interested in…

External References

Leave a Reply

Your email address will not be published. Required fields are marked *