Ananth,

That should be automatically catered for by Excel.

Can you give more details on the problem, the data and how it manifests?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Ananth" wrote in message
...
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