little dashes in excel report out put - need help

[pooja]

To remove /0 in excel report output, we did format by applying Divide by zero characters-0 and report looks fine.

But the problem is after doing that we are getting little dashes on left top corner of the each cell where the values is 0. (report output in excel)

Is there any way to remove those dashes.


thanks,
P

[Grim]

Zero suppression:

http://www-01.ibm.com/support/docview.wss?uid=swg21370735

http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.pwr_ppweb.8.4.0.doc/pwr_ppweb_id2506suppressvalues.html

http://www-01.ibm.com/support/docview.wss?uid=swg21342856

http://www-01.ibm.com/support/docview.wss?uid=swg21339598

[pooja]

But my question is, how to resolve dashes in excel.

[Grim]

Root cause is due to divide by 0 issue right? Then zero supress and you won't have that problem in the first place.