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 values and right-click the selection.
- Select Format Cells.
- 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 guide: Windows 8 Cheat Sheet: Keyboard Shortcuts. Microsoft Windows has always had some fantastic time-saving keyboard shortcuts designed to make our lives easier. For example: CTRL-X will cut text or objects, and CTRL-V will paste them. (Of course, you can use your mouse to achieve the same thing, but it requires clicking and fumbling through menus, which can be a huge time waster if you cut and paste 50+ times a day). With Windows 8, Microsoft has added many new keyboard shortcuts to their operating system; unfortunately, it's a bit of a learning curve. That's where the Windows 8 keyboard shortcuts cheat sheet comes in! Simply download the guide and reference it when you need to. You'll save a ton of time using your keyboard, rather than reaching for the mouse and flipping through oodles of menus trying to find what you're looking for. Share and enjoy! Click here to download this guide now! Note: this guide 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.