More or Less in MS Excel
More or Less in MS Excel
Not everyone who uses MS Excel is a 'Power User'. Everyone has to start someplace, though, and sometimes all those icons on the toolbar are a bit overwhelming. Sometimes you will find that you have been using MS Excel for months and it has never occurred to you to see what those icons do so I am going to tell you about a couple today that can prove to be very, very useful to you.
Follow along with the steps below:
- Launch MS Excel if it is not already open.
- Look at your Formatting toolbar.
- In MS Excel 2007, look on the Home ribbon.
- Find the button with the zeros and arrows.
- The button on the left will add decimal places to numbers in highlighted cells.
- The button on the right will reduce the number of decimal places in highlighted cells.
You may notice that as you decrease decimal places, the value displayed in the cell is rounded. Be not afraid though; if you glance at the Formula bar you will see that Excel still has the exact value stored in its memory.
When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!

My name is Dennis Faas and I am a senior systems administrator and IT technical analyst specializing in cyber crimes (sextortion / blackmail / tech support scams) with over 30 years experience; I also run this website! If you need technical assistance , I can help. Click here to email me now; optionally, you can review my resume here. You can also read how I can fix your computer over the Internet (also includes user reviews).
We are BBB Accredited
We are BBB accredited (A+ rating), celebrating 21 years of excellence! Click to view our rating on the BBB.