When I run a query in Access, or have large number in Excel, what does it mean when it is a large number with an E-02, or E+02 at the end? Or for that matter, E+/-any number?
This is Exponential Notation (also known as Scientific Notation or Standard Form).
Many times when you are dealing with a number with so many digits, whatever tool you are working with may automatically switch to Exponential Notation in order save space in a database field, or on a calculator screen, or…
When the PLUS symbol is used it means the decimal point has been moved to the RIGHT
When the MINUS symbol is used it means the decimal point has been moved to the LEFT
0.0000000091093822 = 9.1093822×10-9 (where -9 is in superscript) = 9.1093822E-9
910938223420000.0 = 9.1093822×10+14 (where +14 is in superscript) = 9.1093822E+14
APPLIES TO / KEY WORDS
Many thanks to our friend and colleague Steve Sharkey on this one!