scientific notation

Dennis Faas's picture

Display Number Values Greater Than 12 Digits: MS Excel

By default, MS Excel will display large numbers in cells using the scientific notation format. For example, if you were to place the number "1231231231234" into a cell, the resulting display would be "1.23123E+12" as soon as the Enter key was ... pressed. Even if you increased the cell width to accommodate 12 characters, Excel will still display the number in scientific notation. Thankfully, there's a way to display numbers in a format other than scientific notation! The trick is to reformat the cell properties. Here's how to do it: Select the cells that will hold the larger ... (view more)

Subscribe to RSS - scientific notation