Changing the number format using JSON code

Question

Is it possible to change the amounts to German format for the currency. I mean 1.000,00 euros? The dot after a thousand and the comma before cents. right now my sharePoint list is showing 1,000.00. I changed regional setting, still not working. is there any solution for that. your affords are appreciated

Answer 1

@Ghadage Aniket When using currency field in JSON formatting and concatenating some text to its value, it gets converted to string. I searched and tested, however, no such function was found to convert it back to currency in JSON formatting and append the commas (,).

I also tried using Calculated column like the below, same result returned.

A similar thread for your reference:
https://techcommunity.microsoft.com/t5/sharepoint/currency-field-formatting-with-json/m-p/1514591

So, currently, it seems that no way to change the currency format. For this issue, I suggest you submit a feedback on this portal, it is a place for customers provide feedback about Microsoft products. What's more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

---------------------

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.