The #N/A can be hidden with a formula like

=IF(ISNA(formula),"",formula)

The #### might be because the columns are not wide enough, or may be as
result of the #N/A. Try both.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Sunny9210" wrote in message
...
My spreadsheet is a pricing sheet with formulae using lookup in another
worksheet so it fills in the rest of the row automatically. All rows
below
what has been filled in show #N/A in one column and ### in 3 columns. How
can I hide this so the sheet looks clean and still maintain the formulae?