Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello one of my columns in the pivot table shows "blank" as the result.
I do not want the word blank I want a nothing on the cell. How isthis done? thanks |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You could just type over that cell with (blank) in it. (Use a single space???)
If you have trouble, maybe using Debra Dalgleish's pivottable addin would help--besides, there's lots of other stuff in that addin that you may like: http://www.contextures.com/xlPivotAddIn02.html Marilyn wrote: Hello one of my columns in the pivot table shows "blank" as the result. I do not want the word blank I want a nothing on the cell. How isthis done? thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Tables - "(blank)" in rows and cells | Excel Discussion (Misc queries) | |||
When I type "13" the spreadsheet shows "14." Possibilities? | Excel Discussion (Misc queries) | |||
Pivot Tables - How can I "reset" the selections in "Row Field"? | Excel Discussion (Misc queries) | |||
In Excel a cell formatted "currency" shows "######" help! | Excel Worksheet Functions | |||
How do I disable "Get Pivot Data" when working from pivot tables? | Excel Worksheet Functions |