NULL from Developer isn't NULL in Excel

[samuray76]

Hi,
i have small problem with NULL value, when i import data to Excel.
Normally in Excel when you make operations on null cells, you get "0" as a result; e.g. adding two null cells gives "0" value.
When i export data from Developer and there are nulls, i get "#ARG" result, although "normal" null cell is equal 0. Why and how identify what sign is in the null cell from Developer and what in "normal" null cell in Excel ?!

Regards
Samuray76

 

[Marco Kalter]

How do you export data to Excel? Do you use the "Copy to Excel" function? For null values I simply get empty cells in Excel.

 

[samuray76]

Yes,
i use "copy to excel" function and i indeed get empty cells in Excel. But in such "empty" cell has to be sth else that in normal excel empty cell.
E.g. when in cell "C6" is a formula:
=C4+C5 and C4 and C5 are "normal" empty cells
i receive 0 as result.
In case these two empty cells are from Developer in "C6" cell i get "#ARG" value.
Why?!