pivot table options--> format, empty cells to -

[lezawang]

Hi
I have pivot table which has empty cells. I right click on an empty cell --->Pivot table Options-->Format and checked "for empty cells show [ - ]
I entered - but instead of showing - it shows 0
I do not have problem if I entered x for example; only - converted to 0
why is that? Thank you very much

 

[Alex Blakenburg]

Exactly why I am not sure but if it did accept is, it would accept is as text and put it to the far left of the column which would be really ugly.
You are better off letting it return a 0 and then use number format on the field to get a very nicely aligned "-"
(without the quotes)