Change Decimal Comma to Dot in Excel Mac

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,


A little experiment: If you find this post and ad below useful, please check the ad out :-)




8 thoughts on “Change Decimal Comma to Dot in Excel Mac

  1. Please note that you may need to restart your computer for the changes to take effect. After upgrading to high sierra, my mac was set to a different region, so I followed the directions above to revert to proper settings and it only worked after restarting the computer.

    just adding this note in case someone else has the same problem.

    Thank you for the original post though, it was helpful.

  2. You open the foreign formatted worksheet on your Mac, select the column with the comma decimal separator, and “paste as values” on an empty column. This will change the number formatting to your default.

  3. It worked (Changing Mac settings) and just came back to click on your “little experiment” ;)

    Thanks for the advise

Leave a Reply to Jose Menendez Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Scroll to top