How can I get up-to-date currencies into my excel with european format?

[JoramPomstra]

Hi, for school I have to do an assignment whereby I have to convert the following currencies into euro's:

- USD (American dollars)
- GPB ( Brittisch pound)
- NZD (New Zealand Dollar)
- INR (Indian Rupees)
- AUD (Australian dollar)

I have found a website (www.http://x-rates.com/table/?from=EUR&amount=1) which I imported into my excel file however, because I work with the European format, my excel thinks that these valuta's are amounts of millions. Does someone know how I can fix this problem? Or maybe a better way to get up-to-date valuta's into my excel file?

It would really help me a lot!

 

[RedBeard]

Replace . with , ?

 

[JoramPomstra]

Replace . with , ?

Yes, the problem is that my excel is Dutch and the data I imported from the website is American, I have searched for Dutch valuta sites but there are just a few and these sites cannot be imported into excel as far as I know. Do you know how I can import these valuta's in my excel sheet and that it is in European format?

 

[RedBeard]

Just do a search and replace and it should be fine, or am I missing something?