Hello everyone,
when I type in my numbers (an amount of money) I usually see it as e.g. € 1.100.100,10 for "one million one hundred thousand one hundred Euros and 10 Cents". The cell is formatted as number with two digits, as this is how I usually need it. However, for my Chinese customer I need to switch the punctuation. He wants it like . € 1,100,100.10 How can excel do this automatically? I don't want to change it by hand every time.
I really appreciate all your help!
Thank you!
Bookmarks