Numbers: Limit number of decimal places shown

I use two productivity suites on a regular basis; Microsoft Office, and Apple Productivity Apps (formerly known as iWork), leaning towards the latter for most things. One of the things I do, is create spreadsheets with interdependencies, so that if I change one input, the output at the other end changes, too. One annoying thing about this, is that, by default, Numbers shows a large number of decimal places.

Luckily, this is readily changed; here’s how:

  1. Mark the cell or cells in question, and go to the Cell tab in the Format menu
  2. Set the Data Format you want, then the number of Decimals you want

That’s it. I wish they would make a global setting for this, and let us set exceptions instead, but this does serve me pretty well.







By posting a comment, you consent to our collecting the information you enter. See privacy policy for more information.

This site uses Akismet to reduce spam. Learn how your comment data is processed.