I would like to find all cells containing the number 18 in an Excel 2007 worksheet where the numbers are in a column with entries in General format (both numbers and strings).
When I use the Find command, enter 18 in the search box, and hit 'Find Next', Excel sequentially moves the cursor to many cells that are not 18, such as 13, 14, etc as well as 18. Or it says 'MicroSoft Excel cannot find the data you are searching for' when in fact I see cells with 18. The problem is not consistent; it did not occur when I tried the search again later. What is going on?