find

[pierre]

hello

i have the following data :

A
1 0
2 20
3 0

i am using ctrl+f to search for zeros only . but i am getting : 0 ,20 , 0.
what should i do in order to get only : 0 for a1 and 0 for a3 ??

 

[Rick Rothstein \(MVP - VB\)]

Click the Options button on the Find dialog box and put a check mark in the
box labeled "Match entire cell contents".

Rick