[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\)[_702_]]

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

Rick


"pierre" wrote in message
...
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 ??