== What does 'E' stand for? == Numerical output from SPSS and other packages sometimes features a numeric decimal followed by an 'E' which in turn is followed by a number. This simply means 'to the power of 10'. e.g. \$\$2.3E-1 = 2.3 x 10^text{-1}\$\$ = 0.23 and, conversely, \$\$2.3E+1 = 2.3 x 10^text{+1}\$\$ = 23.0. Some programs also output a 'D' which means the same thing. * There is a [[http://pages.infinit.net/rlevesqu/Scripts/PivotTables/UndoSciNotation.txt|scripting program available]]. Just cut and paste the syntax into a scripting window, click on pivot table with the 'E' notation and run. In EXCEL 2007 you can remove the single precision 'E' in a cell and convert to a more interpretable decimal by going to the cell (or highlighting a range of cells) and clicking '''Home''', choosing '''format''' in the 'cells' section, choosing '''format cells''' in the resulting toolbar and clicking the '''Number''' tab. Choose the number of decimal places you would like and then click '''Custom''', choose '''0.00''' and click '''OK'''.