Converting amounts using Excel 2003 and 2007

Asked By clark_anderson 250 points N/A Posted on - 10/21/2011

 

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.  

• Status: Open
• Question Views: 786
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By lee hung 75 points N/A #106660

Converting amounts using Excel 2003 and 2007

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.

About lee hung

Questions
3

Answers
1451

Best Answers
463

• Vote Up 0 Vote Down

• Posted on - 10/23/2011
• Question Category: MS Excel