Filter a column that is formatted as currency in excel 2010

[mtanislav]

Hello,

I have a column that is formatted in currency (accounting). Choices:
1. How can I filter it so that it will show only USD or Euro or RON?
2. Or how do I make an exchange formula? If it is ron to only show the value, if it is usd to *with 2,8, if it is euro to * with 4,16
3. Or how do I transform the column in 2 columns, one showing the currency and one showing the value.

Number 3 is more convenient, but any solution will be fine.

Please help a noob

Thanks

 

[mtanislav]

I will try it and let you know. Thanks

PS: excel is so complex, never thought it was so.

 

[mtanislav]

I have excel 2010 and it does not seem to work

any other ideas ?