SOLVED

Currency unvoluntary change

%3CLINGO-SUB%20id%3D%22lingo-sub-2122093%22%20slang%3D%22es-ES%22%3ECurrency%20unvoluntary%20change%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2122093%22%20slang%3D%22es-ES%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3EWe%20are%20constantly%20facing%20the%20following%20issue%20on%20Excel%20-%20Office%20365%20(Windows%20-%20Desktop).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-%20In%20the%20file%2C%20there%20are%20cells%20with%20Euro%20currency%20format%20(%E2%82%AC)%3C%2FP%3E%3CP%3E-%20Another%20users%20enters%20de%20file%2C%20but%20sees%20the%20same%20cells%20as%20dollars%20(%24)%3C%2FP%3E%3CP%3E-%20Later%20on%2C%20the%20first%20user%20also%20sees%20dollars.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20could%20be%20the%20problem%3F%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2122093%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2122154%22%20slang%3D%22en-US%22%3ERe%3A%20Currency%20unvoluntary%20change%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2122154%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F590864%22%20target%3D%22_blank%22%3E%40Manu_Lanuza%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20depends%20on%20Windows%20regional%20settings%20on%20each%20of%20computer%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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.

7 Replies

@Manu_Lanuza 

It depends on Windows regional settings on each of computer

@Manu_Lanuza 

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

 

@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.

 

 

 

 

I'll try and let you know.
Thanks for your time!

@Sergei Baklan , This is what I have in the format:

Manu_Lanuza_0-1613121185677.png

 

If I select the personalized option, I can see this:

Manu_Lanuza_1-1613121238696.png

 

If I move to a cell, where the automatic-unvoluntary change occured, the format is set to:

Manu_Lanuza_0-1613121481140.png

 

 

best response confirmed by Manu_Lanuza (Occasional Contributor)
Solution

@Manu_Lanuza 

That'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

image.png

or as

image.png

In second case format is country specific:

image.png

@Sergei Baklan 

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.