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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Glen Disteafno" wrote in message news:43u0h.24$Z66.6@trnddc07...
| Is there a way to not get a #N/A when a lookup in invalid. I would
| rather have a -0- appear?
| Glen