Home

Number formatting

AK57mentions
New Contributor

Hi 

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

Cheers

2 Replies

Hi,

 

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

Automatically insert a decimal point.png

 

Hope that helps

Regards

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