Pivot Reports and < or > values

N

news

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
 
D

Debra Dalgleish

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.
 
Top