+ Reply to Thread
Results 1 to 3 of 3

Avoid round up of decimals

Hybrid View

  1. 07-09-2014, 03:09 PM #1
    kjxavier
    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
    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 
    =TRUNC(A1,2)
    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
    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:

    =ROUNDDOWN(A2,2)
    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