
Kasey Morris
Member
Members

Forum Posts: 7
Member Since:
April 6, 2022
April 6, 2022

Hi
Looking for advice and help with Pivot table, I have several values that should be 0 (zero) but instead they are E numbers (for example -2.1316282072803E-14), and so I cannot filter them out as not a true Zero.
The values are ....
-98.355
37.148
44.085
-17.123
-34.245
68.49
-7.955
-44.672
44.672
-71.596
65.326
-42.676
43.302
-13.599
-27.19
-54.389
108.777
Grateful for any advice. Thank you!
Kasey

Anders Sehlstedt
Eskilstuna, Sweden
VIP
Members

Trusted Members

Trusted Members

Forum Posts: 880
Member Since:
December 7, 2016
December 7, 2016


Alan Sidman
Steamboat Springs, CO
Member
Members

Trusted Members

Trusted Members

Forum Posts: 174
Member Since:
October 18, 2018
October 18, 2018


Riny van Eekelen
Örnsköldsvik, Sweden
Moderator
Members

Trusted Members
Moderators

Trusted Members
Moderators

Forum Posts: 616
Member Since:
January 31, 2022
January 31, 2022

Didn't you get your answer here?

Alan Sidman
Steamboat Springs, CO
Member
Members

Trusted Members

Trusted Members

Forum Posts: 174
Member Since:
October 18, 2018
October 18, 2018


Mynda Treacy
Admin

Forum Posts: 4620
Member Since:
July 16, 2010
July 16, 2010

Hi Kasey,
Posting in multiple forums is against all forum rules, including ours. You must declare cross posting so we know not to waste time on questions that are already answered.
Mynda
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Mynda Treacy
Guest(s) 11
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
Hans Hallebeek: 186
Newest Members:
Kate Dyka
Kwaje Alfred Mogga
thong nguyen
Appiagyei Kofi Frimpong
Hilary Burchfield
Richie Wright
Adel Kock
Barbara Murray
Doug Milne
Siobhan Stringer
Forum Stats:
Groups: 3
Forums: 24
Topics: 6546
Posts: 28657
Member Stats:
Guest Posters: 49
Members: 32832
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —
