Hi Jean, and welcome to the forum.
When Monarch extracts values from the report, and no value exists for a record for the fields you're after, it assigns what's referred to as a null value to the field.
Under the View options, you can instruct Monarch to display whatever you want when it detects null values. This might be "(Null)', "No data found", " ", "0" or what have you.
But what it exports to Excel or other file formats is different than what it displays in the Table or Summary windows, and this is important.
Monarch will export the exact value of the field, null, to Excel because that really is the value of the cell (regardless of what is being displayed), and Monarch wants to be accurate in how it handles your data.
So when you really want a zero value in your Excel file when nulls exist, you have to set things up just a little differently.
First, you need to convert the nulls to zeros. You do this by creating a calculated field in the Table window. For your Hours fields, I'd start by naming it PreHours. This is my convention for knowing that I want to do something else with the field, and that any Pre fields shouldn't be included in any final output.
Build a new Hours calculated field with this formula:
This will give you zeros where no hours data exists, and the proper hours when a value does exist.
Do the same for the Dollars, and then hide PreHours and PreDollars.
Your export to Excel will then contain the zero values that you want.