1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved Allow Cell in Excel to Show Three Decimals Without Rounding Up

Discussion in 'Business Applications' started by Cookiegal, Aug 14, 2018.

Thread Status:
Not open for further replies.
Advertisement
  1. Cookiegal

    Cookiegal Administrator Malware Specialist Coordinator Thread Starter

    Joined:
    Aug 27, 2003
    Messages:
    115,196
    I'm not that well-versed in Excel (MS Office 2010) but am using it to create a comparison of the nutrients/minerals etc. in dog foods for my own personal use but when I enter a value of 0.099% it rounds it up to 0.10% automatically. I'm sure it's a simple matter but can't figure it out so I would appreciate knowing how to prevent this from happening
     
    Last edited: Aug 14, 2018
  2. cwwozniak

    cwwozniak Trusted Advisor Spam Fighter

    Joined:
    Nov 28, 2005
    Messages:
    64,140
    First Name:
    Chuck
    When you format a cell to show percentages, you can specify how many decimal places should be used. The default is 2 decimal places. Changing it to 3 should do the trick for ya.
     

    Attached Files:

  3. Cookiegal

    Cookiegal Administrator Malware Specialist Coordinator Thread Starter

    Joined:
    Aug 27, 2003
    Messages:
    115,196
    Thanks Chuck. That was very easy and painless. I appreciate it. :)
     
  4. cwwozniak

    cwwozniak Trusted Advisor Spam Fighter

    Joined:
    Nov 28, 2005
    Messages:
    64,140
    First Name:
    Chuck
    You're welcome.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1214465

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice