Dos not work correct "Search" function

[LInc]

Hello,

I use MS Excel 2002 (10.6809.6804) SP3
and have some troubles:

when I use Search function (Ctrl + F) in WorkSheet, Excel could not find
same data. Randomly it may find same or not /with same conditions of search
on same data/.
I make example (Screenshot please look here:
http://img205.imageshack.us/my.php?image=555jv4.jpg ) in my WorkSheet - I
ask Excel to look position with No 68361310 (you may see it below in sheet)
and it could not find it. Why?

Thank you for yours reply’s

 

[Niek Otten]

If 68361310 is the result of a formula, you should not use Look in Formulas, but Look in Values

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hello,
|
| I use MS Excel 2002 (10.6809.6804) SP3
| and have some troubles:
|
| when I use Search function (Ctrl + F) in WorkSheet, Excel could not find
| same data. Randomly it may find same or not /with same conditions of search
| on same data/.
| I make example (Screenshot please look here:
| http://img205.imageshack.us/my.php?image=555jv4.jpg ) in my WorkSheet - I
| ask Excel to look position with No 68361310 (you may see it below in sheet)
| and it could not find it. Why?
|
| Thank you for yours reply's
|

 

[LInc]

Hello, Niek

thank you for your reply,

No, it's not a result of formula. It's just a figures.