Joseph Michael Pesch
VP Programming

Excel Calculated Cell Expecting 0 and Getting Scientific Exponential Notation Instead (e.g. 1.23E+10)

by 5. January 2012 14:38

When adding up several cells of positive and negative decimals (that total 0) I was instead getting a scientific exponential notation like 1.23E+10.  To solve this problem I changed the "Number Format" property on the calculated cell from "General" to "Number" with a fixed set of decimal places and the issue went away.

Tags:

Excel

Comments are closed