converting website visitors
Microsoft Office Tip & Tricks Menu
Tip & Tricks Menu

How To Round Off All Decimal Values In A Row Or Column In MS Excel

Monday October 31, 2016 at 11:42am
Working with numbers comes with a few rules and one such rule that deals with numbers in decimals is to round them off. If you work with Excel, you know that it doesn’t round off numbers unless they’re being treated as currency. If you’re dealing with other types of numbers i.e. non-currency ones, and need to round off numbers to certain decimal point, there’s a pretty simple way to do it.      

Open the MS Excel file you’re working with and select the cell, entire row, or entire column that you want the app to round off. In the ‘Home’ tab, go to the Number set of tools and you will see two buttons next to each other The one with the arrow pointing left will increase how many decimal places are shown for a number. If there are no numbers, it will simply add a zero. The button with the arrow pointing right is the one you need. That’s the one that ’rounds’ the numbers up. Click it once and it will reduce the decimal places shown by one position and round the last digit up. Click it again and it’s reduced by one more decimal point.

Take for example you have a number 4.125. If you click the decimal place button with the left arrow once, it will change the number to 4.1250 i.e., one decimal position will be added. If you click the decimal place button with the right arrow once, this same number will change to 4.13 rounding the ‘2’ to a ‘3’.

You can apply the round-off rule to entire rows and columns, and multiple cells so if you’ve got a table with a lot of rounding up to do, the process will be easy and not redundant.
» Categories: Microsoft Excel


There aren't any comments for this post yet. Why not be the first to comment?

Leave a Comment

Your Name
Email Address (kept hidden)

So that we can check that you are a real person (and not a crafty computer),
answer this simple sum:

What is 13 - 5?
Intec Business Colleges - Established For Over 30 Years
Microsoft Office Specialists - Approved Microsoft Courseware
Intec Business Colleges Ltd, Old School, Pennington Court, Rugby, Warwickshire, CV21 2BB, UK. VAT Number: 695223026 Company Number: 2494959
tel:01788 575090 fax:01788 575411
Website Design by ZARR Ltd