On my pivot table most of the numbers are "normal" but some display in scientific notation (-1.4210854715202E-14). When I change the format in Field Settings to number they look normal. However, when I copy and paste the data to another sheet (as values) it displays in scientific notation again (-1.4210854715202E-14).
Any help is greatly appreciated.
Jeff
Any help is greatly appreciated.
Jeff