The #N/A error is usually the result of a formula..........try wrapping that
formula in an IF statement, like......

=IF(ISNA(YourFormula),"",YourFormula)

Vaya con Dios,
Chuck, CABGx3




"The Toasterman" wrote:

A spreadsheet I am working on return #n/a into a cell as it only dins a blank
in the validation menu we are using.

Is there any way to get excel to ignore #n/a & show a blank?