Thursday, September 10, 2015

Comma separator in excel changed to semicolon (FIX)




If you are used to manually typing formulas in MS Excel, you notice some change after upgrading to Windows 10. The usual comma used to separate arguments was suddenly changed into a semicolon.


It may be a very slight change but may create a great impact if you have been using comma for years, or if you have created automated macros that are designed to use comma as separator.


If you are in the same situation as mine, you might want change the separator back to comma so let’s get started.

1.       Open your Control Panel (right click on Start Menu then choose Control Panel, or type “Control Panel” on the start menu)
2.       Choose Change date, time, or number formats under Clock, Language, and Region.



3.       In the Region dialog box, choose Additional settings... under Formats tab:



4.       In the Customize Format dialog box, under Numbers tab, change the List separator from semicolon to comma or any value/symbol that you wish to use.



5.       Apply all changes.

   Welcome back Comma!


        -Dexter Magalang




No comments:

Post a Comment