Format to show "-" when "0" within cubeviews

Try this..should work

 NumberFormat = [#,##0.00; #,##0.00 ;"-"]

Hi XtensibilityGuy 

Thanks for asking the question. I learned something new as well.

This should work -- 

    If (CellAmount = 0.00) Then
        NumberFormat = "-"

Would appreciate a Kudo. 

Cheers,

Mustafa 

Make sure you consider the ExcelNumberFormat, ReportNoDataNumberFormat, and ReportNumericBindingFormat.  A simple solution is to create some literal value parameters to use as formatting on the Cell Format Formatting within your cube views.   Here's a sample of our standard number formatting for non percentage values.