Quick question I have a pivot table that reflects negative dollar amounts. However when I double click any of the cells the drill down returns ######### and states Dates and times that are negative are to large to display. Any ideas on how to change the display?

The data table and pivot table both are formatted as currency. I send this report to several people so reformatting every time they click in a cell is not favorable.

Thanks.