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

0 Replies