Foreign Number Formatting

[Jet35]

Hello,

I'm trying to automatically convert number formatting to match the style in some European countries by swapping the comma and period position from the USA style of, "123,456.78" to read like, "123.456,78". The problem I'm running into though is when I go to though...

• I go to Number > Custom > "Type:" Field
• I try manipulating the existing format of, "#,##0.00"
• But when I change the comma to a period and period to a comma, it thinks I want it to say, "123456.789"

I've done this before with other formulas like "SUBSTITUE()", but it's ideal to just have the formatting done automatically.

Any thoughts?

I appreciate the help!

 

[shg]

Options > Advanced > Editing Options, untick Use system separators, ...

It's an application-wide setting.