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:
- Mark the cell or cells in question, and go to the Cell tab in the Format menu
- 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.