Excel showing long numbers in scientific notation

It's very common for Excel to format cells containing large numbers in scientific notation.

To see the number just as a value in Excel, highlight the cell in question, right-click on it and choose Format Cells. Select Custom and choose one zero. You should now see the data in the cell formatted as a simple number.

Have more questions? Submit a request

Comments

Article is closed for comments.