I have an issue where by my pivot table is showing dates in the drop down and $. However, my source data is in the date format and once i select a date (in $ format) it will then display as a date, but only on the drop down will it show up as a $.
Any idea what could be the issue or fix?
Bookmarks