Share via

Currency Format for South Africa - SharePoint

Ashwyn Assy 0 Reputation points
2025-06-03T09:22:38.3333333+00:00

Good day.

The currency format for South Africa is incorrect in SharePoint online. It shows a comma for the decimal separator instead of a period.

The locale for the SharePoint site is set to English (South Africa)

Image

When creating a list item in this site, with a currency column, the format is incorrect (as below). South Africa uses a period as the decimal point separator. Not a comma.

Image

I do not want to amend the regional setting as it will affect other things. Can Microsoft please correct the currency format for South Africa.

Thank you.

SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
3,665 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jack-Bu 930 Reputation points Microsoft External Staff Moderator
    2025-06-03T10:54:52.5066667+00:00

    Dear Ashwyn Assy,

    Thank you for contacting Microsoft Q&A Forum and bringing this matter to our attention regarding the incorrect currency format displayed in SharePoint Online when using the locale "English (South Africa)."

    I understand how frustrating this limitation can be, especially when precision in currency formatting is crucial for your work. However, at the moment, SharePoint Online:

    • Does not allow customization of the decimal format inside a Currency column.
    • And it inherits the number and currency format directly from the site’s Regional Settings, which are based on the underlying locale (Culture Info).

    Unfortunately, changing the Regional Settings at the site level can affect several other aspects of your site, such as:

    • Date and time formats
    • Number separators
    • Calculated columns and formulas

    Due to these impacts, I do not recommend changing the Regional Settings as a workaround in this case.

    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.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.