Home

Excel number format

3manped
New Contributor

Until recently, I am sure that if I entered a number with 0 decimal places I simply entered the number and it was correct.  Now I am forced to add a decimal point.  Has something change or have I got it wrong and it was always the case?

 

For example, if I enter 18 with decimal places seet at 0, and do not add a decimal point the result is 0. 

2 Replies
Ensure that your number format is set to General.

@Twifoo 

 

Thank you.  Yes, it is set to General, but the issue remains.  To input a whole number with the decimal places set at '0' I have to add a decimal point after the number: if I don't, it goes to 2 decimal places.  E.g. if I enter '18' without adding a decimal point and with the number of decimal places set to '0' the result is 0.18!
Related Conversations
Office 365 Home for Mac
Amex1966 in Office 365 on
0 Replies
Copy/paste no longer working in Excel
Jon Firooz in Excel on
76 Replies
changing Date format in a pivot table
ahmad ali in Excel on
12 Replies
runtime error 1004 : Method range of object - 'Global' failed
Lorenzo Kim in Excel on
16 Replies
INDEX & MATCH interrupted by Inconsistent Dates
shade206 in Excel on
18 Replies
!SPILL error with SUMIFS formula
Dzung Vu in Excel on
18 Replies