Hi,
the reason to why your "zero" shows up as a blank, is probably a setting in your Excel. If you type a zero in a completely empty (new) sheet and still gets a blank here is what to do:

Tools, Alternatives, View tab, click the "Zero values" check box, or look here:

http://office.microsoft.com/en-us/ex...998791033.aspx

Kind regards
Bjorn