Excel Online - Change default decimal separator Hi In my Country the standard for the decimal separator is dot, but in our Office 365 environment every excel file we have uploaded changes from dot to comma as a separator when working online on the file. Say for example, in your day to day work, you need 2 digit separator and one particular Excel file, you need to use 3 digit separator, then you will need to use a custom format. In the example we change the column Order Date to the right format. The default is the system decimal separator character. On the File tab, click the Options button: 2. But i would like to have a macro that will change … Unlike previous versions, Excel 2010 inserts point on numeric keypad DEL button instead of comma, this post covers how to map comma with Numeric keypad DEL button.
As a workaround, we suggest you try the same steps as mine and see if the separator will change to comma (,). Change separator in excel Module, and paste the following code in the Module Window.
