excel formula conversion question

Question

This may be a little basic math question : But does anyone know how to convert this number: 6.31E+06 ??? This is in excel. when i click on it i get this value :6311730

Please help and I apologize for the super basic question.

Thank you.

Answer 1

Make your column wider and your number should show up correctly. Also, double-check the formatting of the cell and make sure it is in a standard numeric format, not engineering notation.

Answer 2

6.31E+06 is a exponential notation used for long numbers it mean: 6.31 * 10 to the power of 6. 6310000.

Have a look at here for excel number conversions: http://support.microsoft.com/kb/214233

Answer 3

Excel is converting it to scientific notation, probably because the cell is too small to display the value. You can make the cell wider, or change the formatting to not use scientific notation, or format as text which will prevent Excel from interpretting the data as a number.

Answer 4

I think you can just set the format of the cell to general and it will appear correctly