In Switzerland we use ’ (apostrophe) as thousand separator (and . as decimal separator).However the locale de-ch has a comma (which is wrong) as thousands separator. Changing to ’ does not work, as PHP recognizes this character it as the end of the string. Escaping it with a \ (backslash) does not work (it escapes the backslash to \.Any other possibilities? I want to write numbers as #'##0.00
- Note that the “,” and “.” in the number/currency/format pattern is not the actual characters, do not change it, you may read Locale Settings,
- The grouping character of “de-CH” is correct, it is “’”, not “'”. You may click Tools → Locale Settings and search “de-CH” to check.