+ Reply to Thread
Results 1 to 3 of 3

Avoid round up of decimals

  1. 07-09-2014, 03:09 PM #1
    kjxavier is offline
    Registered User
    Join Date
    07-20-2011
    Location
    Kerala, India
    MS-Off Ver
    Excel 2013
    Posts
    93

    Thumbs up Avoid round up of decimals

    Hi!

    I have a column with numeric values

    Eg:
    12345.7256
    545569.3896
    21254.582
    3265.223

    Result obtained when formatted as Numbers with 2 decimals:

    12345.73
    545569.39
    21254.59
    3265.22

    Actual needed result: (Round up not necessary)only exact values

    12345.72
    545569.38
    21254.58
    3265.22


    Thank you in advance.
    Reply With QuoteRegister To Reply
  2. 07-09-2014, 03:12 PM #2
    Jack7774 is offline
    Forum Contributor Jack7774's Avatar
    Join Date
    08-31-2012
    Location
    Georgia, US
    MS-Off Ver
    Excel 2010
    Posts
    576

    Re: Avoid round up of decimals

    You can use the following formula if A1 is the number you want to not round 
    Please Login or Register  to view this content.
    Thank those who have helped you by clicking the Star * below their name and please mark your post [SOLVED] if it has been answered satisfactorily.
    Reply With QuoteRegister To Reply
  3. 07-09-2014, 03:14 PM #3
    ConneXionLost is offline
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Avoid round up of decimals

    Try:

    Please Login or Register  to view this content.
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] MAX(Round to no decimals
    By dmad81 in forum Excel General
    Replies: 10
    Last Post: 06-27-2012, 05:53 PM
  2. Round Decimals
    By Ocean Zhang in forum Excel General
    Replies: 2
    Last Post: 01-16-2011, 09:32 PM
  3. Avoid String been converted to decimals in CSV files.
    By krishnarao in forum Excel General
    Replies: 1
    Last Post: 06-11-2009, 09:19 AM
  4. Excel 2007 : Round Up Decimals
    By librarycustodian in forum Excel General
    Replies: 2
    Last Post: 05-30-2009, 03:01 AM
  5. [SOLVED] How do I ROUND() round off decimals of a column dataset?
    By Højrup in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-12-2005, 07:06 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1