headermask image

Business Tools Blog

Microsoft Excel - How to round numbers in the same cell without a formula

Microsoft Excel - Round numbers in the same cell without a formula

Micorsoft Excel has a neat feature called Precision As Displayed. Using this function automatically rounds all of the numbers in the spreadsheet to equal the number displayed.  You can round without using the “=Round(number,round to number of digits)” formula.

For example, the number in cell C1 is 12.5467 and the number displayed is 13

Photobucket

Turn on Precision as displayed by selecting Tools > Options > Calculations tab, then and checking the Precision as displayed box

Photobucket

Miscrosoft Excel will warn you, that by changing the Data, you will permanently loose accuracy.  If you click “OK”, all of the hard coded numbers in your spreadsheet will be rounded to the number displayed in your spreadsheet.  The formulas will not be changed.

Photobucket

The result, in our example, is that the 12.5467 becomes 13.

Photobucket

If you liked my post, feel free to subscribe to my rss feeds

Money Making Options

Post meta

This entry was written by Sandi Mays and posted on March 24, 2009 at 12:56 am and filed under Excel. Bookmark the permalink. Follow any comments here with the RSS feed for this post. Post a comment(Latest is displayed first) or leave a trackback: Trackback URL.

Share with others

Post Microsoft Excel - How to round numbers in the same cell without a formula to digg. Post Microsoft Excel - How to round numbers in the same cell without a formula to Reddit add to stumbleupon Google Bookmark myweb bookmark on del.cio.us newsvine Tailrank magnolia Furl co.mments shadows simpy blinklist

2 Comments so far (Add 1 more)

  1. Respected sir,
    Please tell about calculation of an electric bill if consumed units are 370 first 100 units rate is Rs, 3.32 and other units rate is Rs, 5.13 and remaining 170 units rate is Rs, 8.07

    1. Muhammad Arshad on October 26th, 2009 at 11:45 pm

  2. This is a dangerous setting, as it permanently removes data. It affects the entire workbook, so not only is the nice report on sheet 1 made more beautiful, but the data on sheets 2 through 5 is truncated, and any important precision is discarded.

    It’s much safer and much smarter to write a couple ROUND formulas, so you are controlling which specific pieces of data are being rounded. With ROUND, you can still trace back to the original data with its original precision.

    3. Jon Peltier on March 24th, 2009 at 4:19 am

One Trackback

  1. By Business Carnival - April 5, 2009 « Business Carnival on April 5, 2009 at 11:01 am

    […] Mays presents Microsoft Excel - How to round numbers in the same cell without a formula posted at Business Tools […]

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*