+ Reply to Thread
Results 1 to 4 of 4

Changing commas to periods and vice-versa in European currency denominations

  1. #1
    Registered User
    Join Date
    06-09-2009
    Location
    Dubai, UAE
    MS-Off Ver
    Excel 2003
    Posts
    29

    Changing commas to periods and vice-versa in European currency denominations

    I have a large table of values denominated in Euros. For some reason, Germans switch commas and decimal points (eg 700.000,00).

    As a result, my American excel program on my American machine does not recognize the numbers properly. And as far as I know, I can only Find/Replace either the comma or the period, and do the other manually, because once I fix one, then for example, I'll have periods for both commas AAND decimal points. All of this also confuses the Format Cells: Number tab, making it impossible to address the issue there.

    Is there a way to change the symbols without reconfiguring the settings on my entire system each time I want to do this?

    Thanks in advance...
    Last edited by tpillow; 06-15-2009 at 08:57 AM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Changing commas to periods and vice-versa in European currency denominations

    Run an Edit -> Replace as you say but as follows:

    Run 1: replace . with nothing (see note)
    Run 2: replace , with .

    note: you don't need any delimiter in 700,000 ... XL will see 700000 as 700,000 automatically

  3. #3
    Registered User
    Join Date
    06-09-2009
    Location
    Dubai, UAE
    MS-Off Ver
    Excel 2003
    Posts
    29

    Re: Changing commas to periods and vice-versa in European currency denominations

    OK, so there's no way to make the program recognize the decimals and commas as currency, and then reformat the currency denominations accordingly, without changing Windows settings?
    Last edited by tpillow; 06-18-2009 at 02:13 AM.

  4. #4
    Registered User
    Join Date
    06-09-2009
    Location
    Dubai, UAE
    MS-Off Ver
    Excel 2003
    Posts
    29

    Re: Changing commas to periods and vice-versa in European currency denominations

    My bad... I marked this "solved" prematurely... thanks for the help but I should have been more specific... I will use your proposed solution if that's all that's available, but see my previous post for a follow-up question.
    Last edited by tpillow; 06-18-2009 at 02:15 AM.

+ 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