Converting amounts using Excel 2003 and 2007

Asked By 250 points N/A Posted on -
qa-featured

 

I need help on converting an amount in Euro in Excel 2003. This is to be used for a German supplier that itemized bills for parts in German mark bills. How can I convert it to euro? Please state in your answer on how to do it using Excel 2003 and Excel 2007.  

SHARE
Answered By 10 points N/A #106660

Converting amounts using Excel 2003 and 2007

qa-featured

Hi Clark,

Can you just right click on the cells that you want to change the currency settings to euro, then choose format cells.

Scroll down to special and press enter.

Change the country setting to United Kingdom.

That should help you fix the problem you are facing.

NB: This should be applicable to both ms 2003 and ms 2007.
If that does not apply, then should be a way that you add module in the visual basic application (VBA) interface which is accessed by pressing CTRL+F1 key combination on the keyboard: A module that is able convert currencies from one to another.

Hope this helps.

___

Regards,

Lee Hung.

Login/Register to Answer

Related Questions