"Excel cannot find the data you are searching for" but I can see i

D

d41sy

I have made a workbook with some numbers in, i.e. 0001 - 9999 and another
column with 00000 - 99999 (not all of these num,bers but just some in a
sequence).

When I then try to find these numbers, Excel "cannot find the data you are
looking for" even though I can see the number in front of my eyes on the
workbook!

Any help with this confusing problem would be very greatly appreciated,
Many thanks
d41sy
 
D

dlw

could it be rounding? for example, enter 1233.9999 and it displays as 1234,
if you search for 1234 it will not find it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"excel cannot find the data you are looking for" but i can see it! 1
How do I set focus (and select text) on a text box on a modeless userform? 0
how can i change a sequence of numbers using find replace 2
Excel Bug 0
How can I add letters to page numbers in Excel. 2
Find and Replace error 3
"Excel cannot find the data you're looking for" 5
how can I use Word find and Replace to search inside a stringvariable (in a macro) 1

Top