The thousand separator (comma ,) & decimal (dot.) is used as default numeric
format in our region (Asia). I need to send the Excel File to my Director in
Germany who use thousand separator (dot) & decimal (comma). The excel file
has nearly 100 thousand cells numeric data based on which a Management
dashboard is created. Because of change in the practice in the region, the
dashboard returns value error.

I want to provide a macro to my director, who will effortlessly run the
macro which will change the cells to the Europe regional format and display
the dashboard results correctly.

Any help please