Scientific Notation

[Gaura215]

Hello

I am stuck in a wierd situation. I have a data, with which I creates
Pivot. Some of the value coming in Pivot are Zero, however some of thos
Zeros are though displayed as Zero, but when I press F2 to go into tha
cell they have values like 4,54747350886464E-13 or 2,27373675443232E-13


My problem is that, I need to create a filter to remove all Zeros fro
that pivot, but as they are written in scientific notation, I am unabl
to filter all ZERO from my data. Please can some one help.

Regards
Gaura

 

[Ron Rosenfeld]

Hello

I am stuck in a wierd situation. I have a data, with which I creates a
Pivot. Some of the value coming in Pivot are Zero, however some of those
Zeros are though displayed as Zero, but when I press F2 to go into that
cell they have values like 4,54747350886464E-13 or 2,27373675443232E-13.


My problem is that, I need to create a filter to remove all Zeros from
that pivot, but as they are written in scientific notation, I am unable
to filter all ZERO from my data. Please can some one help.

Regards
Gaurav

For the formulas that create those values, you could round them to the desired level of precision.
You could filter on a small value that is within your desired precision.
You could set Precision as Displayed as an option, but this is rarely recommended as it is a workbook-wide option, and can have deleterious effects if you require greater precision in your calculations than you would like to display.