CODEWITHSUNDEEP
sharepointsharepoint-2016
pache78
pache78

Reputation: 3

Unable to remove decimal from number in Number Column in SharePoint

I have a number column in a sharepoint list with the following settings in place (see screen shot). I need to only see a whole number but a decimal still displays even though 0 is selected for decimal places. Is it possible to remove the decimal from the number?

Thanks

screenshot

Upvotes: 0

Views: 879

Answers (2)

Heather
Heather

Reputation: 1

I had the same problem with decimals not going away. I fixed it by right clicking on edit for that column then chose "more options" dropdown then I clicked "No" on the "Use thousands separator" toggle and the decimals finally went away. Just remember to also choose "0" for number of decimal places as well.

Upvotes: 0

Xyza_MSFT
Xyza_MSFT

Reputation: 409

After my tests, only integers will be displayed after selecting 0 for decimal places.

You can try the following to see if that solves the problem:

  1. You could try to clear browser cache then restart it.

  2. Try to use a different browser or your browser's InPrivate mode to see if the same error occurs.

  3. Whether all SharePoint lists have the same problem? You could create a new number column in another SharePoint list to check.

Upvotes: 0

Related Questions