Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Reports and < or values
Hi,
Does anybody know how to get Excel to display a less than (<) or greater than () value in a pivot report? In my data list I have values such as <0.003 or 165, yet in the pivot report, Excel displays them as 0. Thanks, Michael |
#2
|
|||
|
|||
Pivot Reports and < or values
If the less than and greater than operators are typed in the source
data, they change the numbers into text. In the pivot table, text is displayed as zero in the data area. Perhaps you could use a custom number format in the source data, instead of typed operators, and the values would display correctly in the pivot table. wrote: Hi, Does anybody know how to get Excel to display a less than (<) or greater than () value in a pivot report? In my data list I have values such as <0.003 or 165, yet in the pivot report, Excel displays them as 0. Thanks, Michael -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|