![]() If it's negative, zero or a character string, this cell will be formatted using the default rules. That's the string that applies if the value is positive. It probably shows a basic Percentage string, perhaps "0.0%". Up 'til now you've set the format as a Percentage now go to the same Format-Cells dialog and select the Custom category. ![]() You can set that by worksheet, so that one worksheet displays zeroes and another displays blanks.Ģ) If you want to control it by particular columns or cells, you can do it with a custom format. I forget what it looks like in earlier versions of Excel, but in 2010 it's under Advanced options and it's labeled "Show a zero in cells that have a zero value". In normal Excel-and I don't see why pivot tables would necessarily be any different-there are two usual ways to do what you're asking:ġ) If you want to do it all the time, you can set one of the Options. My son tells me I should learn pivot tables, but I don't know much about them yet.īut I just took a look at the question, and it sounds like pivot tables may not be relevant. I didn't read this at first because the subject line specified "pivot table".
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |