| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"(Blank)" return when importing from Access
Hello,
How do I specify in Excel or Access so when performaning pivot table in Excel it does not return a "(Blank)" field but instead treat it as 0? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"(Blank)" return when importing from Access
In Excel right click on a cell in your pivot table and select TABLE OPTIONS.
Locate the FOR EMPTY CELLS, SHOW field in the FORMAT OPTIONS panel and enter a 0 (zero). Click OK to to exit and return to the worksheet. -- Kevin Backmann "Cam" wrote: Hello, How do I specify in Excel or Access so when performaning pivot table in Excel it does not return a "(Blank)" field but instead treat it as 0? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"(Blank)" return when importing from Access
Kevin,
Thanks for responding, I did what you suggested, but it still shows (blank) as the result. "Kevin B" wrote: In Excel right click on a cell in your pivot table and select TABLE OPTIONS. Locate the FOR EMPTY CELLS, SHOW field in the FORMAT OPTIONS panel and enter a 0 (zero). Click OK to to exit and return to the worksheet. -- Kevin Backmann "Cam" wrote: Hello, How do I specify in Excel or Access so when performaning pivot table in Excel it does not return a "(Blank)" field but instead treat it as 0? Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"(Blank)" return when importing from Access
If it is a blank in one of the data panes, row or column, then just select
blank from the dropdown and unhide it. -- __________________________________ HTH Bob "Cam" wrote in message ... Kevin, Thanks for responding, I did what you suggested, but it still shows (blank) as the result. "Kevin B" wrote: In Excel right click on a cell in your pivot table and select TABLE OPTIONS. Locate the FOR EMPTY CELLS, SHOW field in the FORMAT OPTIONS panel and enter a 0 (zero). Click OK to to exit and return to the worksheet. -- Kevin Backmann "Cam" wrote: Hello, How do I specify in Excel or Access so when performaning pivot table in Excel it does not return a "(Blank)" field but instead treat it as 0? Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"(Blank)" return when importing from Access
Bob,
I cannot hide them, I need it to return or treat it as 0 instead of (blank). "Bob Phillips" wrote: If it is a blank in one of the data panes, row or column, then just select blank from the dropdown and unhide it. -- __________________________________ HTH Bob "Cam" wrote in message ... Kevin, Thanks for responding, I did what you suggested, but it still shows (blank) as the result. "Kevin B" wrote: In Excel right click on a cell in your pivot table and select TABLE OPTIONS. Locate the FOR EMPTY CELLS, SHOW field in the FORMAT OPTIONS panel and enter a 0 (zero). Click OK to to exit and return to the worksheet. -- Kevin Backmann "Cam" wrote: Hello, How do I specify in Excel or Access so when performaning pivot table in Excel it does not return a "(Blank)" field but instead treat it as 0? Thanks |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"(Blank)" return when importing from Access
Then Kevin's solution is the way to go.
-- __________________________________ HTH Bob "Cam" wrote in message ... Bob, I cannot hide them, I need it to return or treat it as 0 instead of (blank). "Bob Phillips" wrote: If it is a blank in one of the data panes, row or column, then just select blank from the dropdown and unhide it. -- __________________________________ HTH Bob "Cam" wrote in message ... Kevin, Thanks for responding, I did what you suggested, but it still shows (blank) as the result. "Kevin B" wrote: In Excel right click on a cell in your pivot table and select TABLE OPTIONS. Locate the FOR EMPTY CELLS, SHOW field in the FORMAT OPTIONS panel and enter a 0 (zero). Click OK to to exit and return to the worksheet. -- Kevin Backmann "Cam" wrote: Hello, How do I specify in Excel or Access so when performaning pivot table in Excel it does not return a "(Blank)" field but instead treat it as 0? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Iserror - can it return a "blank" value? | Excel Discussion (Misc queries) | |||
| How do I return "leave cell blank" using IF logic. | Excel Worksheet Functions | |||
| Avoiding "0" importing blank cells from another Excel file | Excel Discussion (Misc queries) | |||
| Return blank for true "if" statement when charting, not 0 | Charts and Charting in Excel | |||
| Changing "returned" values from "0" to "blank" | Excel Worksheet Functions | |||
Linear Mode
