I'm trying to find a value in a worksheet and Find is not working. If I search for text it works, but when I look for a value it doesn't find what I want. Here is what I enter: "Find what:" 50,000 "Within:" Sheet "Search:" By Rows "Look in:" Values "Format:" Number. No other options. (I also tried just the number and no comma, but it did not work either.)
What is weird is there is a button or box that says "Preview*" that doesn't do anything and I can't get rid of it. I pasted a screenshot of it. Any ideas what is wrong?
@Sergei Baklan - thanks for your reply. It still doid not work. I tried what you said and added a ".00" to my 50,000 example. It matches the format exactly but does not find the value.
I tried another sample by using a new worksheet and two values like you did. At first it did not work like my earlier attempt. Then I tried to find 50,000 without the ".00" and out of the blue it worked! It also worked on my original worksheet. Maybe it was clicking the "thousands separator" in the find format that did it.
@RichinMesa , in Find what: bar it shall be the number without any formatting. Not 50,000 not 50000.00 Only 50000. If you don't add Format option, it finds any 50000, doesn't matter how it is formatted. If you add format options, it finds only 50000 formatted as you defined.
If you try to find 50,000 or 50000.00 it finds nothing. More exactly no one number - Excel will be finding text "50,000", not number.