Monarch is only displaying /Izeros; the actual value is still null, so that's what makes its way to Excel.
The way to resolve this is to create a calculated field in the Table window that will convert nulls to zero, and then use that calculated field as the summary measure.
Usually the formula look like this:
iIf(MyField=1/0,0,Myfield)[/code]There's a mention of how Monarch treats null values in the "View" section in this piece entitled "[URL="http://********************/tips/breaking-all-the-rules"]Breaking All The Rules[/URL]", which is part of the currently underway [URL="http://********************/tips/30-days-to-become-a-better-monarch-modeler"]30 Days to Become a Better Monarch Modeler[/URL] series.
I think there are valid reasons for preferring a separate calculated field for this. Numeric values may be subject to auditing and having a single field and its formula to audit seems to me to be preferable to checking on a field by field basis to identify where a zero value came from. In other words an explicit formula may be more convincing than a default transformation parameter! This would be especially true, I suspect, when using the new Monarch Context facility from V10.5.
Your profile indicates you use V8 but that information may be out of date.
If you have V9 or later you could save your 'Null to zero' conversion field as a generic User Defined Function to make it generally available for future use. It would save the need for remembering the formula or having to look for it other models each time you need to cut and paste it into a new model.