If you've already converted to values, then:
select your range
edit|Replace
and replace all.

If you want to adjust your =vlookup() formula:

=if(iserror(vlookup()),"",vlookup())
or
=if(iserror(vlookup()),0,vlookup())


hdc wrote:

When I use V-lookup, I often have numerous results that appear as "#N/A". I
would like to be able to delete all of the "#N/A" values, or replace them
with a 0, withour have to individually select and delete them.

--

Dave Peterson