Decimal Place

**Pale Cloud** · 04-06-2011, 04:05 AM

Hi

My Excel 2011 Mac has decided that I need to always type a dot after I enter a number.

If I just type 23 and hit enter, the cell will show 0.23, I need to type 23. in order to get 23

Any ideas?

Thank you in advance.

**se1429** · 04-06-2011, 05:20 AM

Go to Excel options --> advanced. There is a check box that says "automatically insert a decimal point". Clear the check box.

I don't have the MAC version but hopefully the menus are the same or similar in both.

Regards.

**Pale Cloud** · 04-06-2011, 05:32 AM

Thank you for that but the mac version seems to be different; I have preferences in this and there is no option to untick this box. Searching the help does not help either!

Originally Posted by se1429

Go to Excel options --> advanced. There is a check box that says "automatically insert a decimal point". Clear the check box.

I don't have the MAC version but hopefully the menus are the same or similar in both.

Regards.

**TMS** · 04-06-2011, 05:45 AM

This may help, although I don't have a Mac:

http://support.microsoft.com/kb/305567

Regards

**TMS** · 04-06-2011, 05:50 AM

Note that I found this by using Google: Mac Excel Decimal Point

The post relates to the Fixed Decimal Places setting.

There are other results that might be of interest, notably a Mac forum where this exact issue is discussed.

Regards

**Pale Cloud** · 04-06-2011, 05:51 AM

Thank you. I see it now but it is cunningly hidden as 'Display this number of decimal places'

This has been driving me nuts for months!

**TMS** · 04-06-2011, 05:54 AM

You're welcome. It's all in what you see and how you interpret it, isn't it. Not always easy.

If this is now resolved, please mark the thread as SOLVED.

To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save

Regards