Excel behaves slightly differently on Mac and Windows when it comes to separators and regional settings. If a formula or CSV works on one and not the other, these differences are usually why.
Where the separator comes from
- Windows: the list separator and decimal symbol come from Control Panel → Region → Additional settings, and Excel can override them under File → Options → Advanced → Use system separators.
- Mac: Excel follows the macOS region settings in System Settings → General → Language & Region. Excel for Mac also has Preferences → Edit → Use system separators to override.
In both cases the rule is the same: a decimal point region uses a comma between arguments; a decimal comma region uses a semicolon.
Common cross-platform surprises
- Different region defaults. If your Mac and PC are set to different countries, the same formula may need a comma on one and a semicolon on the other.
- CSV delimiters. Saving a CSV on a Mac set to a European region can produce semicolons; opening it on a US Windows expects commas. See CSV semicolons.
- Keyboard shortcuts differ (Cmd vs Ctrl), but that doesn't affect formula syntax.
Keeping formulas portable
- Set both machines to the same region if you move files between them often.
- Share the
.xlsx file rather than formula text — the file stores formulas neutrally, so separators adapt to each Excel automatically.
- To convert a formula's separators between the two conventions once, paste it into the formula translator.
Key takeaways
- Mac reads separators from macOS region; Windows from Control Panel — both overridable in Excel.
- The comma/semicolon rule (tied to the decimal) is identical on both platforms.
- Sharing the file, not the text, avoids most separator problems.
← All Excel guides