Converting UK Currency to Euro format
Results 1 to 5 of 5

Thread: Converting UK Currency to Euro format

  1. #1
    New Member
    Join Date
    Feb 2014
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Converting UK Currency to Euro format

    Hello

    I posted this yesterday but I think it was in the wrong place. Sorry.

    I have a worksheet where all the values are written in UK format, e.g.

    10,000,000.00
    7,500.12
    100.00

    I need to have them in Euro format, i.e.

    10.000.000,00
    7.500,12
    100,00

    The built in Currency Formatting isn't working for me. It's putting an extra 2 zeros in the value. Nor is Find/Replace.

    Hope some one can help


    Best

    David

  2. #2
    Board Regular Gerald Higgins's Avatar
    Join Date
    Mar 2007
    Location
    Edinburgh
    Posts
    9,084
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Converting UK Currency to Euro format

    Try this.

    File
    Options
    Advanced
    Untick the box for "Use system separators"
    Then in the box for "decimal separator", you probably have the "." character, replace this with ","
    And similarly for "thousands separator", replace "," with "."
    The following is my SIGNATURE. It's not part of any question or solution I'm posting. If it IS your solution, you've got a very weird problem !

    Sub Macro()
    ActiveCell = "IY" & Right(Application.Name, 5)
    With ActiveCell.Characters(Start:=2, Length:=1).Font
    .Name = "Webdings"
    .Color = 255
    End With
    End Sub

  3. #3
    New Member
    Join Date
    Feb 2014
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Converting UK Currency to Euro format

    Gerald....Thank You!!!

    Your solution works perfectly

    I have tried to reply before but each time I tried to send I got logged out.

    A small follow-up question. If there are zeros following the decimal point, in the formula bar, I don't see the zeros. But if there are numbers there I see them. I'm just curious why this is.

    Best

    David

  4. #4
    Board Regular Gerald Higgins's Avatar
    Join Date
    Mar 2007
    Location
    Edinburgh
    Posts
    9,084
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Converting UK Currency to Euro format

    The formula bar shows the underlying value that Excel is holding, and this disregards any formating that may have been applied to the cell.

    For example, if you enter the value
    1
    in a call, you can format this to display in the cell as
    1.00
    but the formula bar always just shows the
    1
    That's just the way Excel is, and I think knowing that can be helpful.
    On this board there are quite often questions from people who are confused about why their cell is displaying a different number from what they expect, and the reason is often cell formating.
    Comparing the formula bar with the cell's appearance can give you a clue to this.
    The following is my SIGNATURE. It's not part of any question or solution I'm posting. If it IS your solution, you've got a very weird problem !

    Sub Macro()
    ActiveCell = "IY" & Right(Application.Name, 5)
    With ActiveCell.Characters(Start:=2, Length:=1).Font
    .Name = "Webdings"
    .Color = 255
    End With
    End Sub

  5. #5
    New Member
    Join Date
    Feb 2014
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Converting UK Currency to Euro format

    Thanks Gerald...Makes sense...very clear answer.

    Best

    David

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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