+ Reply to Thread
Results 1 to 2 of 2

Decimal translation problem

  1. #1
    Francis Hayes (The Excel Addic
    Guest

    Decimal translation problem

    Someone asked me the following question. Any suggestions?

    -------------------
    Another problem is in scenarios with figures with a decimal, in English this
    is a '.' (point) and in other languages, like dutch, it is a ',' (comma).
    When I send a model to someone using the other decimal-seperater, the model
    produces lots of errors (because a number becomes text). I think that Excel
    should change this automatically. I don't know where to report these 'bugs',
    do you? And if so, you probably never get an answer from Redmond.
    -------------------
    --
    Have a great day,
    Francis Hayes (The Excel Addict)

    http://www.TheExcelAddict.com


  2. #2
    JE McGimpsey
    Guest

    Re: Decimal translation problem

    The "someone" should use their native decimal separator.

    XL automatically converts the decimal separator, based on the user's
    regional settings.

    Numbers never get converted to text by XL based on the decimal
    separator. It is true, however, that if the *user* enters numbers as
    text, XL isn't prescient enough to override his or her choice.



    In article <C76CC6D6-7C74-4858-9A09-E6BC27993A9D@microsoft.com>,
    "Francis Hayes (The Excel Addict)"
    <TheExcelAddict@discussions.microsoft.com> wrote:

    > Someone asked me the following question. Any suggestions?
    >
    > -------------------
    > Another problem is in scenarios with figures with a decimal, in English this
    > is a '.' (point) and in other languages, like dutch, it is a ',' (comma).
    > When I send a model to someone using the other decimal-seperater, the model
    > produces lots of errors (because a number becomes text). I think that Excel
    > should change this automatically. I don't know where to report these 'bugs',
    > do you? And if so, you probably never get an answer from Redmond.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1