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 6 Comments
  • margarida November 28, 2011, 8:58 pm

    hi! in my excel i want to change

  • mi November 28, 2011, 8:59 pm

    Hi! in the excel i want to change the comma (,) to dot (.). any idea? thanks!

  • Ravi Shankar November 29, 2011, 6:12 am
  • Marilyn February 22, 2013, 6:32 pm

    I tried this – it does not “take”. please advise.
    Thanks

  • suzan LoCascio June 17, 2017, 5:42 pm

    Hi
    My Excel for Mac defaults to assuming all numbers you type include the tenths and hundredths places. For example if I type in 575 – it shows as 5.75 rather than 575.
    any idea how I change this default? it’s driving me batty!
    thank you so much!

  • Ravi Shankar June 17, 2017, 7:29 pm

    Can you please try using format cell option and specify the number of decimals required for the column or worksheet.

    Regards,
    Ravi

Leave a Comment

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