I need to set up a filter so that only rows with a numeric values 0 show.
(No rows with text or a zero in C will show)

Another tinker to play with ..

Try in say D1:
=IF(TRIM(C1)="","",IF(ISTEXT(C1),"no",IF(C1+0<=0," no","yes")))
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Wayne Knazek" wrote:
In a nutshell . . . A TEXT FILE IS IMPORTED . . .

In column C (example) there will either be text, a numeric value, or a
"zero" (0).

I need to set up a filter so that only rows with a numeric values 0 show.
(No rows with text or a zero in C will show)

I tried to set up a helper column that (example) would have a "yes" in
column D if the cell (C1) had a plus value, and "no" if it had text or a
zero.

I used . . . =IF(C1<=0,"no","yes") Works OK to eliminate cells with a zero
or negative number. There's a "no" in the next column.

I figuresd I'd get a "yes" in the columns with only text.

BUT NO! If there's text in the column, other than the number 0, it counts
as a numeric value. So I get a "yes" in any row with text or a value greater
than zero.

0 enters a no (good!)
a negative number enters a no (Yazza!)
a positive number enters a yes (poifec!)
any text enters a yes (NO!)

Hmmm. Comments welcome.