Number formatting

New Contributor


I have just purchased Office 365. When using Excel i have the following problem, not sure what I am missing but when I enter the number 12 it shows up as 0,12. When I type in 12.00 it shows as 12,00.

I have tried the number formatting with no luck. Please can you show me where to change this so that when I enter the number 12 it shows up as 12,00


2 Replies



Go to Excel Options and make sure that the following option is turned off:

Automatically insert a decimal point.png


Hope that helps


Thanks a lot for the help. I appreciate it.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies