Convert currency formats EUR->USA and USA->EUR in Excel

Asked

Viewed 57 times

1

My problem: Convert a Range Excel with currency format (USD) to (EUR) and vice versa.

Format USD 123,456,789.00

Format EUR 123 456 789,00

I tried to encode a replacement in VBA but I am a beginner in these things.

Can someone help encode a macro or function in Excel that solves this situation?

excel vba

1 answer

1

It would be a normal replace, like removing the commas and putting spaces; And removing the dots and putting commas?
Cell format is in text or number?
If you want to repeat yourself, just put a loop to the end, anything edits your questions with additional information.

well, try this:

 Range("A1").Select
    Cells.Replace What:=",", Replacement:=" ", LookAt:=xlPart, SearchOrder _
        :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False

    Cells.Replace What:=".", Replacement:=",", LookAt:=xlPart, SearchOrder _
        :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False

Browser other questions tagged excel vba

You are not signed in. Login or sign up in order to post.