Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 replys |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 | |
#3
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Hello, Niek
thank you for your reply, No, it's not a result of formula. It's just a figures. "Niek Otten" wrote: 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 | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Will the COUNTIF function work with auto-filtering? | Excel Worksheet Functions | |||
Which excel function would work best? | Excel Worksheet Functions | |||
I want to correct a #div/0! error but the IF function doesnt work | Excel Worksheet Functions | |||
Does excel have a 'cubed root' function? How can it work it out? | Excel Worksheet Functions | |||
clock | Excel Worksheet Functions |