Feb 11 2021 09:41 AM
Hi all,
We are constantly facing the following issue on Excel - Office 365 (Windows - Desktop).
- In the file, there are cells with Euro currency format (€)
- Another users enters de file, but sees the same cells as dollars ($)
- Later on, the first user also sees dollars.
What could be the problem?
Thanks.
Feb 11 2021 10:25 AM
It depends on Windows regional settings on each of computer
Feb 11 2021 10:30 AM
In addition, you may format Ctrl+1 -> currency, select from here. When it'll be
[$$-en-US]#,##0.00
or
[$£-en-GB]#,##0.00
with such prefix currency shall not change
Feb 12 2021 01:08 AM
@Sergei Baklan I'm afraid it's not the case for us.
I've checked following these steps and confirmed that all the users have € as predefined currency.
Feb 12 2021 01:09 AM
Feb 12 2021 01:14 AM - edited Feb 12 2021 01:18 AM
@Sergei Baklan , This is what I have in the format:
If I select the personalized option, I can see this:
If I move to a cell, where the automatic-unvoluntary change occured, the format is set to:
Feb 12 2021 01:28 AM
SolutionThat's since you select default currency, that's the same as assign it from the ribbon. Let me illustrate. My default currency is pound, I may select it as
or as
In second case format is country specific:
Feb 12 2021 01:35 AM
Thanks! Now I understood.
I've just set it as you explained.
I'll do a couple of tests with the rest of the users and come back to the forum.
Regards.
Feb 12 2021 01:28 AM
SolutionThat's since you select default currency, that's the same as assign it from the ribbon. Let me illustrate. My default currency is pound, I may select it as
or as
In second case format is country specific: