you could change your formula to something like this

=if(isnumber(a1),your formula,"")


"Tom" wrote in message
...
here's a question for you excel experts: Is it possible to hide the #value
error message in cells? Here's the scenario: I have a long column of data,
numbers and text. Mainly numbers of course, the text may be headers or
something that must be there to help understand the data. In an adjacent
column, is an equation that is dragged down the column to distribute the
equation. I know the text values will yield a #value error. But, it's just
quicker to drag the equation down, rather than to de-select so many text
cells. The other option is to delete all the #value, but tedious. In
addition, lets just assume all the data has to be in the same column. So
reorganizing the data is not an option, besides, that is also tedious.

Thx,
Tom