Home › Excel guides › Excel separators on Mac vs Windows: why they differ

Excel separators on Mac vs Windows: why they differ

Where Excel takes its argument separator from on each platform, and what to change when a formula moves between them.

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

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

Keeping formulas portable

  1. Set both machines to the same region if you move files between them often.
  2. Share the .xlsx file rather than formula text — the file stores formulas neutrally, so separators adapt to each Excel automatically.
  3. To convert a formula's separators between the two conventions once, paste it into the formula translator.

Key takeaways

← All Excel guides

Copied to clipboard