Print from Airliners.net discussion forum http://www.airliners.net/aviationforums/non_aviation/read.main/258442/ 
Topic: Excel Trouble Username: DC10Tony Posted 20020721 23:41:33 and read 684 times.I'm having trouble with computations on Excel, again.
I've already figured everything out on the calculator, but when I type in some formulas, I get a 2E+06, 3E+06, 7E+05 instead of the number I'm supposed to be getting.
I know I'm doing it right, but I can't figure out why I'm getting these odd numbers instead of my solution. I've tried widening the columns to their normal size, but nothing is working to get rid of the 3E+06, 7E+05, etc.
Any help will be appreciated. 
Topic: RE: Excel Trouble Username: Arsenal@LHR Posted 20020722 01:32:13 and read 672 times.Can you elaborate a bit, what numbers are you suppose to be getting?

Topic: RE: Excel Trouble Username: Deltaflyer Posted 20020722 03:33:15 and read 667 times.DC10....
Looks like you have the cell formatted for scientific notation with zero decimal places. This gives you only one significant digit.
Click on the cell with the calculation, and format it for more decimal places, or as a "number" rather than "scientific"
Let me know if you need any additional help.
Pete 
Topic: RE: Excel Trouble Username: Indianguy Posted 20020722 20:31:17 and read 648 times.That happened with me when the col size wasnt enough to fit the data. Try extending the cell width.
Roy 
The messages in this discussion express the views of the author of the message, not necessarily the views of Airliners.net or any entity associated with Airliners.net.Copyright © Lundgren Aerospace. All rights reserved. http://www.airliners.net/ 