Unanswered

SharePoint list number format is different from an user to another

(0) Share

Report

Posted on by malecos

Hello, my friends!
I have a SharePoint list to input some data, including decimal numbers.

In my country, we use comma as the decimal separator.

It's strange, because when I input the decimal numbers, everything works fine. The same for some of my co-workers, but for some of them, SharePoint converts the input numbers to something similar to currency.

This is how the numbers appear when I input them:

This is how the numbers appear when some users (not all) input them:

They must be 12,50 and 12,58 and 12,55 and 12,60

The list is the same for all users.

The Windows language and region configuration is the same for all users.

The decimal separator set in Windows is the same (comma) for all users.

I don't want to use the column json formatting style, because if the list works for me, it must work for other users as well.

Could somebody try to help me, please?

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

David_MA 12,908 Super User 2025 Season 2 on at

Like (0)

Report

Re: SharePoint list number format is different from an user to another

This isn't really a Power Automate question, but one regarding SharePoint. However, what you see is due to the settings in the user profile. Just change your preferences in your user profile to use commas or decimals.

The easiest way to access the user profile is to open the Delve app and choose Me and then Update profile. Then look for this on the page:

Do what it says for accessing the regional settings, and it will bring you to:

Click on the three dots and choose Language and Region from the menu. The locale determines how dates and numbers will display:

Was this reply helpful? Yes No
malecos on at

Like (0)

Report

Re: SharePoint list number format is different from an user to another

David_MA, thank you for your reply!

Unfortunately, it didn't work.
Even following your instruction and setting the Locale configuration to Portuguese - Brazil, the numbers are still being recorded differently depending on user.
See below.
Rows in green = data input by me.
Rows in red = data input by another user.

I'm new here. Which would be the right place to post SharePoint list questions?

Was this reply helpful? Yes No
David_MA 12,908 Super User 2025 Season 2 on at

Like (0)

Report

Re: SharePoint list number format is different from an user to another

The profile settings are per user. Each person needs to update their profile. The changes to your profile have no effect on other people. However, there is one thing that you can do that would affect all users who have not set up their profile preferences. To change this, you must be a site owner.

Go to the site and choose the site settings > Site Information > View all site settings. Under Site Administration, choose Regional settings. You can then choose the preferred locale which affects how numbers and dates are presented in SharePoint.

Note, if people have set up another preference in their user profile, their user profile settings will take precedence over this setting.

Was this reply helpful? Yes No
malecos on at

Like (0)

Report

Re: SharePoint list number format is different from an user to another

David_MA, thanks again for your help!

All users have the locale profile option set to portuguese - Brazil now...

...but even so, numbers are registered differently for some of the users.
See
Rows with green mark are the ones input by me.
Rows with red mark are the ones input by another user, but his locale profile is also set to portuguese - Brazil, so I don't know what can be causing the issue.

Both our machines are set to use comma as the decimal separator in Windows Control Panel

Was this reply helpful? Yes No
David_MA 12,908 Super User 2025 Season 2 on at

Like (0)

Report

Re: SharePoint list number format is different from an user to another

I see commas in all of the numbers in your screen shot.

Was this reply helpful? Yes No
malecos on at

Like (0)

Report

Re: SharePoint list number format is different from an user to another

Yeah, but the difference is that when I insert the numbers, they are stored as 12,70 (twelve dot seventy)
If another user insert the same number, it is stored as 1270,00 (a thousand two hundred and seventy)

Today, I tested the same list for another user and a different case was observed
His Sharepoint list stores the number normally, but does not show the commas

See:
Row with the red mark was input this morning by another user.
The screenshot was taken from the user's screen.
As you can see, the numbers are stored without commas...

... but when I open the same list in my machine, I can see the numbers stored with commas

Another thing to notice is that in my screen the date was stored as 05/05/2024, while in the screen of the other user it was stored normally as 06/05/2024, which is the current date.

Man, this issue is driving me crazy.
A lot of different problems.
For some users, the number is stored with comma but representing more than one thousand.
For other users, it is stored normally, but the user cannot see the commas.
For me and some other users, the numbers are stored normally, showing the commas properly.

To complete the problem, this morning I noticed that the dates are being shown differently depending on user screen.

Thanks!

Was this reply helpful? Yes No
David_MA 12,908 Super User 2025 Season 2 on at

Like (0)

Report

Re: SharePoint list number format is different from an user to another

I would post the issue in the SharePoint forums instead of the Power Automate forums as the issue is with SharePoint and not with Power Automate. The SharePoint forums are at Welcome to the SharePoint group. (microsoft.com)

Was this reply helpful? Yes No
malecos on at

Like (0)

Report

Re: SharePoint list number format is different from an user to another

Thanks, David_MA!

I will do that!

Was this reply helpful? Yes No