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:

  1. Select the cells that will hold the larger values and right-click the selection.
     
  2. Select Format Cells.
     
  3. In the Number tab, select the desired format (e.g., Number) and click OK.

Now when you enter the values that have more than 12 characters, they will be formatted as you specified -- and not using the dreaded scientific notation! ;-)

Wasn't that easy?

Visit Carol's web site to learn more tips like this one!

Free eBook: Getting Started: Your Guide to Windows 8. Windows 8 is arguably Microsoft's most daring Windows Operating system to date. Featuring an unusual tile-based Start screen that's optimized for touchscreen devices, Windows 8 is now available on all new computers, laptops and ultrabooks, and hybrid tablets. Whichever device you use Windows 8 on, you'll need to know a few things. First, how are you going to get the data from your current operating system to the new one? Second, you'll probably be wondering where Windows desktop has gone. Finally, you might be wondering: why did Microsoft remove the Start menu? This eBook answers all those questions, and more. Click here to download this eBook now! Note: this eBook is free, but registration is required; after that, you can select more ebooks and videos for download without registering again. If you have questions / problems with the registration form, please read this.

Free eBook



Problems downloading
eBook? Read this.