+ Reply to Thread
Results 1 to 3 of 3

Changing decimal places to automatically become 0

  1. #1
    Registered User
    Join Date
    02-10-2020
    Location
    England
    MS-Off Ver
    2016
    Posts
    2

    Question Changing decimal places to automatically become 0

    Hi,

    I'm wondering if anyone would be able to help please.
    If I wanted to format a cell that sums up other cells to automatically have zero's after the decimal place i.e. .00, how would I make this possible?
    Eg/ =SUM(A2+A3) = £132.34 (A10) how would I make that round down to £132.00
    Another example would be if the decimal value is above .50, how would I make this round up to .00 eg/ =SUM(A2+A3) = £132.64 (A10) to then read £133.00

    I am currently using Excel 2016.

    If any additional information is required please let me know.

    Thanks so much,

    Jess

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,198

    Re: Changing decimal places to automatically become 0

    your decimal places is determined by formatting to 2 places

    round(your formula,0) should work for the other bit
    eg
    round( SUM(A2+A3),0)
    but is simpler as
    round( A2+A3,0)

  3. #3
    Registered User
    Join Date
    02-10-2020
    Location
    England
    MS-Off Ver
    2016
    Posts
    2

    Red face Re: Changing decimal places to automatically become 0

    Thank you so much, this has worked! Been stuck on that all day!!

    Best Regards,

    Jess

+ 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. [SOLVED] Excel automatically rounds to 10+ decimal places
    By jason4444 in forum Excel General
    Replies: 4
    Last Post: 08-03-2017, 12:01 PM
  2. changing the decimal places without rounding the numbers
    By the_reporter in forum Excel General
    Replies: 5
    Last Post: 11-09-2016, 06:44 PM
  3. [SOLVED] variable type changing number of decimal places
    By russc2541 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-16-2014, 07:43 AM
  4. Excel changing numberto add decimal places
    By joebee78 in forum Excel General
    Replies: 1
    Last Post: 01-30-2013, 12:56 PM
  5. Changing Protected Cell Format to Decimal Places
    By BazzaBoy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-09-2009, 06:54 AM
  6. Replies: 2
    Last Post: 09-17-2005, 05:05 PM
  7. Changing default decimal places
    By Zecarioca in forum Excel General
    Replies: 2
    Last Post: 04-13-2005, 04:06 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