+ Reply to Thread
Results 1 to 2 of 2

Getting Different Rounding Results - Identical Numbers

  1. #1
    Registered User
    Join Date
    04-17-2014
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    1

    Getting Different Rounding Results - Identical Numbers

    So I'm working on a spreadsheets where the numbers are supposed to be rounded to the third decimal place. I have the entire column set to "Number" and decimal places set to 3. I noticed that there was an instance where there there three identical numbers and one was rounded differently. I expanded the number of decimal places thinking there's differences at the 4th or 5th decimal but nope - they're identical.

    Here's what I'm talking about:
    .0445000 -> .045
    .0445000 -> .044
    .0445000 -> .044

    Any help much appreciated.

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Getting Different Rounding Results - Identical Numbers

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Match identical numbers in two columns and display unmatched results
    By currycai in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-25-2014, 06:01 AM
  2. [SOLVED] Two identical codes produce different results
    By BRISBANEBOB in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-15-2014, 09:18 PM
  3. Rounding up results
    By mistral in forum Excel General
    Replies: 4
    Last Post: 08-10-2006, 11:30 AM
  4. Replies: 3
    Last Post: 07-28-2006, 06:00 PM
  5. IF function comare to identical amount but inconsistent results
    By skhuon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-28-2006, 05:15 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1