=========
QUESTION
———
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?

 

=========
ANSWER
———
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

 

=========
EXAMPLES
———
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
———
Microsoft Access
Microsoft Excel
Numbers
Calculations
Math
Advanced

 

=========
REF
———
http://en.wikipedia.org/wiki/Scientific_notation 


Many thanks to our friend and colleague Steve Sharkey on this one!

 


http://www.anysitesupport.com/what-does-e-02-mean-in-a-decimal-number/
http://anySiteHosting.com