Forum Discussion

Steel Contributor

Jul 22, 2024

Solved

SharePoint "Number" field with number of decimals = Zero. will still show the number with decimals

I have this Column of type number and number of decimal = Zero:- now using the SharePoint UI or using Power Apps, if I enter a number with decimals (6.5 for example) seems inside the S...

developer

SharePoint Online

Rob_Elliott
Jul 29, 2024
johnjohn-Peter this works as designed; you have set the number of decimals to 0 so however the number is being added to the list item it will always display with no decimal places even though the underlying number might have decimals.

You will not lose any data by changing the number of decimal places.

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

Rob_Elliott

Silver Contributor

Jul 29, 2024

johnjohn-Peter this works as designed; you have set the number of decimals to 0 so however the number is being added to the list item it will always display with no decimal places even though the underlying number might have decimals.

You will not lose any data by changing the number of decimal places.

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)