Pivot Table Drill Down returning Dates not Currency

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.

Thanks JosephP, the style was set to date and I had to change to General.

The VBA code in this thread will allow you to automatically match the formatting of the source data, or apply custom formatting.

http://www.mrexcel.com/forum/excel-q...ead-table.html