Step 1 We do need to separate the contents of column A but there is data in column B so we need to insert another column between column A and column B. You may have wondered why suddenly Microsoft Excel is using semicolons instead of commas in separating your Excel formulas. Open your Windows settings.
On the File tab click the Options button.
Here you can see Excel inherits the regional settings by default. Httpwwwworksmartertv In this video I show you how to change the decimal separator symbol from a point to a comma or the other way around. A dialog box appears. Select the desired options in Decimal symbol and Digit grouping symbol.