Try setting the entire column to Nur Text. You should see all the numbers left align in their cells.
1 Like
Hello TIMAI2, now it is working.
The problem was that I did set only cell with leading 0 to text format. That will not work.
To set the entire colum B to text format do give the results I want to have.
Conclusion, lesson lerned for me: Format only colums, not single cell - single cell is messup the search.!
Thank you all - and sorry that I did not try this earlier.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.