VEGHATERMEATLOVER Posted October 22, 2009 Share Posted October 22, 2009 I'm on windows 2003 excel. I want to make addition to something but instead of giving the real number it gives this number 1.12329E+11? what should I do. the number is about one hundred billion. Link to comment Share on other sites More sharing options...
sheep455_is_the_best Posted October 22, 2009 Share Posted October 22, 2009 1.12329E+11 IS around 100 billion. It means 1.12329 * 10^11.Excel just "shortens" it. [Whip drops: 13] Link to comment Share on other sites More sharing options...
Smapla Posted October 22, 2009 Share Posted October 22, 2009 that's scienfific notation. e is just a way of writing the exponent of ten by which the first number of multiplied. Link to comment Share on other sites More sharing options...
VEGHATERMEATLOVER Posted October 22, 2009 Author Share Posted October 22, 2009 i've fixed it now. how do I disable it from now on? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now