The "Find" function in Excel 2003 finds what I want sometimes, and on the
next worksheet, it will say "Microsoft Office Excel cannot find the data
you're searching for." I would like to look through a column of numbers, and
they all start with 0.____, or a negative -0.____(fill in the blanks with any
given number ie: 0.452213, or -0.59263). My goal is to identify where the
negative numbers occur. I used the Find and Replace function with the
following settings: "Find what: -0."; no format set, "within: Sheet";
"Search: By Columns"; "Look in: Values".
Any way i can get the Find and Replace function to find what i want?
Much appreciated...