It is very clunky but, you can highlight the Column then select Data
Filter Autofilter click on the arrowhead and then select (Custom ...)

Click on the arrowhead of the top left box and select does not equal and
put a dash in the other top box then click OK.

To unhide the row after entering data you have to re-apply the Custom
Autofilter again, (I said that it was clukky!)

This will not work if the "-" is being entered because the cell is formatted
as Currency

Otherwise get a good book on VBA.
--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"Lee" wrote in message
...
is there a way to hide rows that have a certain character in that row.

example
B1
1
-
-
4
5
The rows with a "-" gets hidden and if the cell gets data other than "-"
later it would unhide the row.

a guy at work said this wasn't possible. without programing. I don't know
that much about VBA. So if that is the only way I guess I will have to
learn

Thanks in advance