Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Display Null Values in Pivot as 0 Display Null Values in Pivot as 0
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 06-02-2016, 09:47 AM
lornalou lornalou is offline Display Null Values in Pivot as 0 Windows 7 64bit Display Null Values in Pivot as 0 Office 2010 64bit
Novice
Display Null Values in Pivot as 0 		 
Join Date: May 2016
Posts: 5
lornalou is on a distinguished road
Default Display Null Values in Pivot as 0

hello everyone. How do I make the blank cells (Nulls) = 0?

(see attachment - sheet Pivot)

Thank you
Attached Files
File Type: xlsx TransferDestination - May 2016 - final.xlsx (143.6 KB, 8 views)
Reply With Quote
  #2  
Old 06-02-2016, 10:34 AM
xor xor is offline Display Null Values in Pivot as 0 Windows 10 Display Null Values in Pivot as 0 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
Select a cell in the pivot table, right click your mouse, Pivot Table Options, For empty cells show: 0
Reply With Quote
  #3  
Old 06-02-2016, 10:39 AM
lornalou lornalou is offline Display Null Values in Pivot as 0 Windows 7 64bit Display Null Values in Pivot as 0 Office 2010 64bit
Novice
Display Null Values in Pivot as 0 		 
Join Date: May 2016
Posts: 5
lornalou is on a distinguished road
Default
thank you so much - appreciated
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Display multiple values as new values based on selection from template. MvdB Excel 2 09-29-2015 08:51 PM
How to create a pivot table with text as values ljd108 Excel Programming 0 01-22-2015 07:48 PM
Pivot Tables - Values divided by Subtotal Loretti Excel 0 11-12-2012 02:15 PM
Display Null Values in Pivot as 0 add values from different variables with pivot table andrei Excel 2 01-19-2012 08:45 AM
Display Null Values in Pivot as 0 Eliminating zeros, null values and negatives in a column jannie Excel 1 06-22-2011 07:03 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:16 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft