Note: The other languages of the website are Google-translated. Back to English
Log in  \/ 
Register  \/ 


file Super find

10 months 1 week ago #3182 by jkm
Super find was created by jkm
If I enter a number into a cell eg 4567.
Then try to find it using super find, 4567 is found regardless of whether the "Type" I'm searching for is "Text" or "Values".
If 4567 is formatted as comma 4,567.00 then neither "Type" or "Values" search will find it - but it will be found if I search for 4,567.
By the way, if I have typed "frog" in a cell, both "Text" and " Values" search will find it!

My questions are:
What is the difference between text & values search?
I would have expected text search to only find text and values search to only find values (regardless of how they are formatted).
If I have 4567 in a cell formatted as comma, then I would expect a "Values" search to find it if I search for 4567.

Please Log in or Create an account to join the conversation.

Moderators: ExcelfansOfficeFansAmanda Lee