Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Scientific Notation

14 views
Skip to first unread message

Gaura215

unread,
May 17, 2013, 2:50:22 AM5/17/13
to

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




--
Gaura215

Ron Rosenfeld

unread,
May 17, 2013, 6:09:20 AM5/17/13
to
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.
0 new messages