Excel Chimp
Board Regular
- Joined
- Oct 30, 2008
- Messages
- 90
Is there an option to just show a blank cell, instead of the "(blank)" text? See Column F. I know there is a way for VALUE area of a pivot table, but what about row labels? Thanks.
Excel 2010
Excel Workbook | |||||||||
---|---|---|---|---|---|---|---|---|---|
D | E | F | G | H | I | J | |||
4 | |||||||||
5 | |||||||||
6 | Lease expiration | Move in | Move out | Resident deposit | Other deposit | ||||
7 | 12/11/2012 | 12/12/2011 | (blank) | 0 | 0 | ||||
8 | 10/19/2012 | 10/20/2011 | (blank) | 650 | 0 | ||||
9 | 6/26/2012 | 6/27/2009 | (blank) | 250 | 0 | ||||
10 | 6/25/2012 | 6/26/2010 | (blank) | 0 | 200 | ||||
one line RR |