hiding #value message in cells
 

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

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

Holy Cow, that's right. I can use an if statement. Where was my head? Thanks
Hark

Tom

"N Harkawat" wrote:

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

hiding #value message in cells
 

Perfect, because of your useful answer i just won a trip to Ibiza :)

"N Harkawat" wrote:

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