Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Excel cannot find the data you are searching for" but I can see i
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Excel cannot find the data you are searching for" but I can see i
could it be rounding? for example, enter 1233.9999 and it displays as 1234,
if you search for 1234 it will not find it. "d41sy" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Excel cannot find the data you are searching for" but I can s
Make sure in options you have formula selected and not values.
"dlw" wrote: could it be rounding? for example, enter 1233.9999 and it displays as 1234, if you search for 1234 it will not find it. "d41sy" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
How to change the default in Excel from "find next" to "find all" | Excel Discussion (Misc queries) | |||
Using "Find" function in Excel 2000, edit data without closing Fin | Excel Discussion (Misc queries) | |||
Find formatting doesn't work: "Excel cannot find data" | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) |