Suggestions for correcting a #N/A Error???

[Guest]

I have tried everything from formatting the cells to sorting the columns and
I have over 10,000 cells to pull from and it would be horrific to have to
type in each one. Any suggestions or tricks that people have found would be
much appreciated. Thanks for all your help!

 

[Simon Murphy]

Matt
you could use conditional formatting to make the font the same colour as the
background
you could use a spare bit of worksheet and put the following formula in
=if(isna(yourcell),0,yourcell) then paste the values over the originals
depends what you are doing with all these errors.
cheers
Simon

 

[Nick Hodge]

Matt

Edit>Go to>Special... check formulas and uncheck all but errors and then
press delete

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)