I set up an external query to pull data from an Oracle database into a sheet
in my excel file. I have array formulas on another sheet that use the
external data as their data source for calculations. The problem is that all
of the array formula results are zero.

I found that if I re-type the data in external data cells, the data is
recognized and my array formula sums increase accordingly. I think there is
some kind of hidden formatting on the external data, but can't find it.
Please help.

Thanks.