Pivot table row labels -Display blank cell instead of "(blank)" text

[Excel Chimp]

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 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

Excel 2010

 

[Andrew Poulsom]

In Excel 2003 you can just overwrite (blank) with a space.

 

[Excel Chimp]

Ok, that does work, interesting. I would have thought there would be a setting for the entire PT.

Thanks.