microsoft excel training class - Exchange rates/Currency conversion

The UK's most regular instructor-led training courses.
Training information: microsoft excel training class · Advanced.excel · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Exchange rates/Currency conversion

Julie has attended:
Excel Introduction course
Excel Intermediate course

by - delegate Julie [3 posts] (2007 Aug 7 Tue, 15:40) Reply

How do I convert the currency of a column? Can I convert a column of totals into 2 different currencies?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	4	book now	£207	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Exchange rates/Currency conversion

by - trainer Jacob gold contributer [104 posts] (2007 Aug 8 Wed, 15:01) Reply

Hi Julie

Right-click the column header you wish to format, then select format cells.

In the format cells dialogue box, select currency.

You can then selct your preferred currency settings.

Note whilst this applies the same setting to all cells in the column, you can change individual cells by right clicking them and repeating the above.

Regards

Jacob