Convert EUR-US and USA-EUR currency formats into Excel

Question

Convert EUR-US and USA-EUR currency formats into Excel

Navigation

#1 by (1 votes)

1

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

Format USD 123,456,789.00

Format EUR 123 456 789,00

I tried to code a replacement in VBA but I'm a newbie to these things.

Can anyone help to code a macro or function in Excel that solves this situation?

excel vba

asked by anonymous 13.03.2015 / 19:20

1 answer

Convention for use of PouchDB with CouchDB Make a javascript work inside a URL

score 1 · Answer 1

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

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