excel consultants - Currency

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

Resolved · Low Priority · Version Standard

Currency

Rowena has attended:
Excel Introduction course
Excel Introduction course

by - delegate Rowena [2 posts] (2007 Aug 6 Mon, 17:17) Reply

how do I format for currency

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: currency

by - trainer Tracy platinum contributer [586 posts] (2007 Aug 7 Tue, 06:06) Reply

Hi Rowena,

Thanks for the question, all the different types of currency options can be found under Format, Cells and go to the category Currency. From there you can pick the appropriate symbol and also change the decimal places.

Tracy

· Database Tips from an Excel Training Course
· Microsoft Office and the Small Business: Part 1 Excel
· Identifying Suitable Candidates For VBA For Excel Training
· Microsoft Excel's Best Kept Secret
· Improve Performance Of Your Excel Macros