Tags: asia, comma, decimal, default, dot, excel, file, format, microsoft, msdn, numeric, region, separator, software, thousand

Decimal dot to Decimal Comma

On Microsoft » Microsoft Excel

5,387 words with 3 Comments; publish: Thu, 22 May 2008 06:17:00 GMT; (30662.50, « »)

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

All Comments

Leave a comment...

  • 3 Comments
    • 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" <Ananth.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      news:71ADD944-7F28-4958-AA3A-CCE72A25BEB1.excel.todaysummary.com.microsoft.com...

      > 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

      #1; Thu, 22 May 2008 06:18:00 GMT
    • 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.

      "Bob Phillips" wrote:

      > 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" <Ananth.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      > news:71ADD944-7F28-4958-AA3A-CCE72A25BEB1.excel.todaysummary.com.microsoft.com...

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

      >

      >

      #2; Thu, 22 May 2008 06:19:00 GMT
    • 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)

      "Ananth" <Ananth.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      news:27CC828D-ABF6-43F5-95FD-942C769D5345.excel.todaysummary.com.microsoft.com...

      > 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.

      > "Bob Phillips" wrote:

      >> 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" <Ananth.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      >> news:71ADD944-7F28-4958-AA3A-CCE72A25BEB1.excel.todaysummary.com.microsoft.com...

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

      >>

      #3; Thu, 22 May 2008 06:20:00 GMT