View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default Dos not work correct "Search" function

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

"LInc" wrote in message ...
| 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 he
| 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
|