2007-12-03 05:08:14 · 3 answers · asked by Mic80 1 in Computers & Internet ➔ Software
The 0 is a result of a sum function, so I can't manipulate that value as '0.
2007-12-03 05:24:06 · update #1
"Values" is not an option in the "Look in" box
2007-12-05 03:36:20 · update #2
Excel 2003 can do this - maybe 2002 can also.
Open the Find and Replace dialog.
Click the Options>> button to expand the dialog to see all options.
On the left at the bottom there is a drop down list for "Look in:" with "Formulas" selected by default. Just choose "Values" from the list.
Then Excel should find all zeros including from the result of a formula. Works for me.
2007-12-03 20:06:05 · answer #1 · answered by vbmica 7 · 0⤊ 0⤋
You can't do that. Excel doesn't see it as zero it sees =1-1 for example. What you can do is copy your range of cells that you want to find zero then do a paste-special in a blank area. You can now do a find/replace in this area.
2007-12-03 15:34:36 · answer #2 · answered by Don R 5 · 0⤊ 1⤋
put a ' in front of the "0". That tells excel that you are not using a formula.
2007-12-03 05:12:24 · answer #3 · answered by 68vette 3 · 0⤊ 1⤋