Number format for -1E-100

[Nuz]

I have a range of cells where some cells have values -1E-100.
I would like to display those values like they are zeros. But since they are actually negative values, my custom number format is not working correctly. I currenly have the number format as:

_-* # ##0_-;_-* (# ##0)_-;_-* -_-;_-@_-

The problem is that -1E-100 is displayed as (0) when I would like to have it displayed as - (like a zero value).

Can I modify the custom number formatting to fix this for -1E-100 values?

 

[Nuz]

Thanks pgc01. That was a detailed look at the problem.
Of course it is theoretically possible the we want to include the leading zeros in some cases (positive and negative cash flows offset each other) as xenou mentioned but i suppose in practice 99,9% of the cases we want to exlude them (there is no data).
This has to be a bug in the XIRR since the ordinary IRR formula ignores always the leading zeros.