Unable to remove decimal from number in Number Column in SharePoint

565 Views Asked by At

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

2

There are 2 best solutions below

3
Xyza_MSFT On

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.

0
Heather On

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.