Skip to content

Change Decimal Comma to Dot in Excel Mac

March 3rd, 2016 - ITTutorial(1 min)

TL;DR: There are two things you can do:

  1. Change in Language & Region -> Advanced…
  2. When converting a text to columns, you can specify the delimiter (Step 3 of 3 -> Advanced…)

Regional settings

The regional settings will affect all applications, not only Excel.

preferences-001

Here you can specify the decimal and thousand delimiters:

preferences-002

Note: You need to remember that applications will now interpret numbers using the new settings.

Excel conversions

Sometimes you need to load excel data form e.g. a CSV file, where numbers, currencies are specified using a different delimiter than you regional one. If you do it blind, you’ll end up with text columns instead of numbers and you’ll need fancy ways to replace the delimiters. Here are the steps:

  1. Select the data and start the conversion process:

    excel-001

  2. Select the delimiter(s):

    excel-002

  3. Select the column formatting (highlight a column):

    excel-003

  4. Select the Advanced… button to customise the decimal and thousands separators:

    excel-004

HTH,

Share on
Reddit
Linked in
Whatsapp

A little experiment: