For example, if your region is Germany (which uses, for decimal separation), Excel will always use for CSVs, even when changing the decimal point under “Advanced” settings. You need to change your general region for it to work.Then Excel will save using semi-colons ( ) If your language / region / locale uses comma ( ,) for decimal separation.Here are the rules Excel uses to determine how it saves CSV files: Then you need to verify the number separators in “Advanced …” > “General”. To change them, go to “System Preferences” > “Language & Region”:
The chosen value separator depends on your RegionĪnd your region's default number separators. Excel for Mac currently has no setting to change the CSV separator from the app itself.
0 kommentar(er)
