Note: The other languages of the website are Google-translated. Back to English
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Saturday, 20 March 2021
  0 Replies
  1.2K Visits
0
Votes
Undo
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.
There are no replies made for this post yet.