how to prevent zero error message for logarithmic plots

[jlrosner]

Somewhere in a very large file, there is a zero placed in a logarithmic plot.
Everytime I use the file I get the repeated error message that this problem
exists. Unless Excel can show me where in this 35000 line sheet the problem
exists, I dont want to repeatedly get this message. It effectively prevents
me from using the file.

 

[Luke M]

Simply do a find (Ctrl+F)
Look for "0"
Under options, look at values, and match entire cell contents.

 

[jlrosner]

Thanks, Luke M, but I have over 6000 "0"s in the file.