With custom number formats, what’s the code to make 0 show up as “–”?
The ‘accounting’ format will give you a ‘-’, but for a ‘–’, try this: _(* #,##0.00_);_(* (#,##0.00);_(* “–”??_);_(@_)
Read this article http://www.yogeshguptaonline.com/2009/04/custom-formating-excel-number-format.html #,##0.00\_);[Red](#,##0.00);–; worked for me.
Cool, thanks guys
I guess it goes [positive];[negative];[zero]
positive, neg, zero, text