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
- Alexander Frolov; “How to convert numbers to text using Excel TEXT function and other options“; Ablebits.com