Skip to content

Numbers: Limit number of decimal places shown

This article was been published more than 6months ago. The information contained herein may be outdated.

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.

Be First to Comment

Leave a Reply