That feels a bit unnatural but is an acceptable trade-off for me. and the thousands separator to, (the thousands separator probably doesn't matter but I wanted to make it consistent with the US formatting)Īn alternative to steps 2+3 would be to change these settings in the system settings (step 1) but I generally want to have numbers formatted according to a Czech locale.ĭownsides: in Excel, I now need to enter decimal numbers using the US locale, i.e. In Excel 2013, I went to Options -> Advanced and unchecked Use system separators (under "Editing Options", which is the first section).I changed the system List separator to a comma in Region -> Additional settings.The default list separator in system settings is. (Note: My PC is using a Czech format settings that format numbers like this: 1 000,00, i.e., comma is used as a decimal separator and space as a thousands separator. This is what worked for me - it is a combination of some of the answers here.
0 kommentar(er)
