I actually found a much easier solution....at least for Quickbooks Online (I've not checked if it works on the desktop version also):

Run any report.  Under Customize, choose Number Format.  UNCHECK the "except zero amount" box.  That's all there is to it!  No need to export to Excel either!