Change Decimal Comma to Dot in Excel Mac

TL;DR: There are two things you can do: Change in Language & Region -> Advanced… 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. Here you can specify the decimal and thousand delimiters: Note: You […]

Excel – Check if item exists in another column

The other day I had to create a “diff” between two lists in excel. More exactly, I had to verify which emails were missing between two lists of emails. Solutions I could find two solutions to this problem, which are listed below. For both, I’ll assume that columns A and B contain the two lists […]

Scroll to top