+ Reply to Thread
Results 1 to 5 of 5

Making Zeros into blanks in a pivot table

  1. #1
    Registered User
    Join Date
    10-16-2015
    Location
    Santa Fe Springs, CA
    MS-Off Ver
    2010
    Posts
    7

    Making Zeros into blanks in a pivot table

    Good morning,

    I created a pivot table from raw data showing the hours worked by employees. In the pivot, there are a variety of numbers, but there are also quite a lot of zeros (0.00). There are also blank spaces. I want my pivot table to be consistent and I could always make the blanks into zeros (which I know how to do), but is there a way to make the zeros appear as blanks without touching the raw data?

    Thank you!

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Making Zeros into blanks in a pivot table

    Hi

    Just untick the 'show a zero in cells that have a zero value' in the Excel settings for the sheet in question.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    10-16-2015
    Location
    Santa Fe Springs, CA
    MS-Off Ver
    2010
    Posts
    7

    Re: Making Zeros into blanks in a pivot table

    Thanks for the quick response!

    Where would the excel settings be? Is it a pivot table option?

  4. #4
    Registered User
    Join Date
    10-16-2015
    Location
    Santa Fe Springs, CA
    MS-Off Ver
    2010
    Posts
    7

    Re: Making Zeros into blanks in a pivot table

    Thanks Richard! I knew the solution was simple, I just couldn't remember where to find it. I just looked it up and found out where it was.

    Once again, thank you!

  5. #5
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,908

    Re: Making Zeros into blanks in a pivot table

    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Averaging data from a table by row name and ignoring blanks/zeros
    By HoneyBadger302 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-01-2015, 10:52 AM
  2. [SOLVED] Pivot Table not filtering out my zeros...
    By phpolicylady in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-19-2015, 12:49 PM
  3. [SOLVED] Replace blanks with zeros inside a VBA created pivot
    By punter in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-06-2014, 05:09 PM
  4. Pivot Table: Zeros to Dashes
    By GreatLakesJK in forum Excel General
    Replies: 7
    Last Post: 01-28-2011, 04:16 PM
  5. displaying zeros when no value in pivot table
    By markcranmer in forum Excel General
    Replies: 1
    Last Post: 05-02-2010, 11:49 AM
  6. Suppress zeros in a pivot table
    By dcgrove in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-13-2009, 05:15 PM
  7. Pivot Table and Zeros
    By Celeda in forum Excel General
    Replies: 0
    Last Post: 01-01-2005, 04:58 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1