Forum Discussion
List currency column formatting - moving the decimal places
I have recently migrated a site from SharePoint 2010 to SharePoint Online, and one of the lists has a currency column which is set to show 2 decimal places. After migration the values in the migrated...
Something similar happened to me a few days ago. When updating values from the Sharepoint list in a currency type column, a different value is saved, not matter if using grid or form view. Examples:
1 ---> 10
10 ---> 100
0.1 ----> 1
0.11 ---> 11
12.34 ----> 1234
If I create a new column of the same type on the same list, the same thing happens. However if I create a completely new list and one of the columns is of type currency, that does not happen. From an App (Power apps) that had the update created, the problem does not occur either.
In my case the currency configuration is € and the country is Spain.
1 ---> 10
10 ---> 100
0.1 ----> 1
0.11 ---> 11
12.34 ----> 1234
If I create a new column of the same type on the same list, the same thing happens. However if I create a completely new list and one of the columns is of type currency, that does not happen. From an App (Power apps) that had the update created, the problem does not occur either.
In my case the currency configuration is € and the country is Spain.
- Same thing happens to me. Suddently (2 days ago) currency column, 2 decimal places and the currency configuration is € and the country is Italy.
The problem is only in the lists. If I use the same column in a doc lib it works.