Decimal dot to Decimal Comma


A

Ananth

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
 
Ad

Advertisements

B

Bob Phillips

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)
 
A

Ananth

The file when opened in germany assumes the dot in the numeric as Text data &
intrepts so. The dashboard which is the summary sheet returns value error,
as the summation of the text cells is not possible.
 
Ad

Advertisements

B

Bob Phillips

You say ... in Text data ... , a dot in text is just a character and so will
not be converted. What text data and how is it used in the dashboard?

--
---
HTH

Bob


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top