Hi all,

Is it possible to show 0s when the cell is empty?

Thanks

--
Message posted from http://www.ExcelForum.com

Can't you just format the table?

-----Original Message-----
Hi all,

Is it possible to show 0s when the cell is empty?

Thanks.


---
Message posted from http://www.ExcelForum.com/

.

Oops, sorry for confusion! :(

I want the code that allows me to do the same things as what I choos
from the Table Option (using pivot table) -- "For empty cells, show
0"

P.S. I start dealing with pivot table in code 2 days ago, and I am ne
to it.

Thanks

--
Message posted from http://www.ExcelForum.com