Number Formatting... Zero's to Dashs

[#1]

I'd like to display zero values as a dash similar to what I can do with an Excel spreadsheet with a format similar to

"_(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)"

So far I haven't found any good way to do this in Qlikview besides replacing the zero value in the expression with a dash.  This is far from ideal as I'd like to retain the actual zero value when exported to Excel.

Thoughts??

[rbecher]

Maybe replace zero with Null(). It's not the same although...

- Ralf

[#3]

Not looking for nulls since I want the zeo to export to Excel.

[#4]

you could modify the expression used in the attachment.

[Gysbert_Wassenaar · Accepted solution]

A format string like #,##0.00;-#,##0.00;- works for me to show 0's as dashes. In QV a dash is shown, when exported to Excel a dash is also shown, but the underlying value is still a 0.