SharePoint Currency Field

Question

Hello Everybody,

I have a strange problem with a Sharepoint Currency field in a SharePoint List. I want to show the values as currency but this is not possible as shown in the picture attached.

The field is set as currency and all the parameters are ok! The strange thing is that I have created another identical List for Testing purpose and in that Lists I am able to see the same number as Currency value as shown in the second picture attached.

At this point I have checked the international settings of the 2 SharePoint Websites where these 2 Lists are located and they have all things and settings the same. All the parameters seems to be the same.

When I export the values in Excel or CSV from the List the values are stored correctly as currency as I show in Picture 3

Any hint or ideas would be higly appreciated

Thanks in advance

Gian Paolo

Answer 1

I found the problem

I formatted the column with black borders like an Excel cell and this formatting is changing the format of the values in the field. If I remove the borders it works fine!!

this is the Json Code for the borders

{
 
"elmType"
"style"
"border"
"padding"
"box-sizing"
 },
"txtContent"
}

Now I have to find a way to have the borders and the currency format!

Answer 2

Hi @Achille Tessitori,

Thank you for posting in this community.

Try using this JSON for your column, as it will keep the price formatting while adding column borders.

{
    "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
    "elmType": "div",
    "style": {
        "border": "1px solid black"
    },
    "txtContent": "@currentField"
}

Here is my test result:

---

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.