List currency column formatting - moving the decimal places

Copper Contributor

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 column have changed, for example: 652,30€ is now 65.230,00€. So i need to move the decimal places for the values to be correct again.

Is there a way to move the decimal points for all elements of this list at once without adjusting it manually? This list has roughly 9500 elements, therefore i'd like to save the time of changing all of them manually.

Thanks alot!
Best Regards

3 Replies
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.
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.
This happens in one of our lists too. Haven't found a fix so far.