I’m attempting to filter a column for different numbers that appear in the column in Excel VBA… The problem is the value of the cell is not the same as it appears on the screen, so cannot filter values based on a string.
i.e. The .Value of the Cell is -312132.138407427 However, it is appearing in the cell as -312132.
I have confirmed this by expanding the view of the number in the cell to exactly as it appears in .Value and it works. Manipulating the cell to a certain format or the .Value is not desirable as it’s not scalable and very in-efficient.
This should be easy to filter for a value that is not a string! Am I missing something?