On my data tab I've got a column for "review date." Some of those cells are blank. When you go to the pivot table, the respective cell for that blank.review date cell displays the date 1/29/14. There is no data in the cell on the data tab, so why would it be displaying 1/29/14? I want it to either say "blank" or just be blank. It does this for every review date cell that is blank.
In pivot table options, do you have a value set for display for blank cells?
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
Yep. I've tried setting it to 0, TBA, n/a, and ---. None of those do anything for that field. All of the other blank cells outside of that field change to those values though.
May you post the workbook?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks