Change decimal places in Excel 2011 for Mac

This articles is about the option available to change the decimal places in Excel 2011 for Mac. Excel by default automatically inserts decimal point after two digits but it allows users to change the default option using the Preferences.

Click the Excel menu and select Preferences from the displayed menu list.
201110021304.jpg
In the Excel Preferences, click the Edit option under the Authoring section.
201110021307.jpg
In the Edit window, tick the check box with label as Display this number of decimal places then enter the number after which you want to insert the decimal point. Click the Ok button to confirm and save the changes.
201110021309.jpg

In Category: Apple, Mac

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 4 Comments

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.