Excel 365 changes my numbers

New Contributor

Excel 365 changes my numbers to percentages - which I DON'T want.

If I enter 46 it is automatically changed to 0.46

I have selected my cells and selected the number format (General) many times and it does not change this.

If I make the format to "Text" it displays as "46" but calculates as "0.46"

The only way I have found around this is when entering, say, "46" I instead have to enter "46.00" Yes, it works but when I am entering many, many numbers it is a lot of extra effort to always enter a decimal point and the irrelevant zeros.

I just want an integer.

Any help would be much appreciated.




3 Replies

@sydman , most probably you have this setting checked


Above is for Windows, for Excel Mac it shall be similar

Thank you @Sergei Baklan 


That was indeed the solution.

@sydman , you are welcome

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
17 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