If cell in column A contains word then format cell in Column B

[Vbanoob98]

Hi I'm trying to figure out how to do what the title says

Currency	Amount
EUR	500.00
USD	600.00
EUR	300.00

So basically if Column A has the word "EUR" then format 500.00 to just 500 and then EUR 300.00 to 300 and so on

Seems simple but what I have found so far seems very convoluted

Thanks a lot for your help

 

[MARK858]

You're welcome