Pivot table showing 0 instead of -

[kafarrell]

I've looked through the forum and can't find an answer to this. In options, I've set it to Calculate as Displayed and my formatting in the pivot table for the Amount column is Accounting with $, but it is showing some 0 (zeroes) as $0.00 or ($0.00) and some as $ - (which is what I want). I don't understand the difference.

[AliGW]

Those values are not dead zero. Select F10 and look at the formula bar. You may need to do some rounding in the underlying data table.

[sandy666]

before	after
currencybefore.jpg	currencyafter.jpg

now is ok?

[kafarrell]

Thank you Sandy!!! This has been perplexing to me for years!

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[sandy666]

You are welcome
Your source table has a custom format as shown in post #3
PivotTable takeover this format so you need to change it manually from the ribbon

Thanks for the feedback and mark thread solved

[DanielKhor]

I have a similar issue. Would anyone be able to help? it seems that it is summing up to 0 but excel pivot takes it as a really small number.

[AliGW]

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread