How to convert column in $ to other column in euro? [closed]
I have a list of prices in $ in column A and need them into euro's in column B. In the help I found the function CONVERT with an example:
Example =CONVERT(100;"ATS";"EUR") returns the Euro value of 100 Austrian Schillings. =CONVERT(100;"EUR";"DEM") converts 100 Euros into German Marks.
and thought putting in column B : =CONVERT(A11,"USD","EUR") would do the trick, but it returns #N/A.
Help ? :) Thy