Isn't there an 'Excel Option' that allows you to enter value (Free Text... IE
N/A) when you get a #/div error?

I know that pivot tables have that option, but I'm not using a pivot table
and I'd like to use that option. Thanks in advance!!