microsoft.excel.training - Currency

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

Resolved · Low Priority · Version Standard

Currency

Marcela has attended:
Excel Introduction course
Excel Intermediate course

by - delegate Marcela [1 post] (2007 Aug 20 Mon, 14:07) Reply

How can a currency be introduced?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 21 Fri	Bloomsbury	3	book now	£224	£235
2007	2008 Nov 27 Thu	Bloomsbury	4	book now	£240	£245
2003	2008 Nov 28 Fri	Southwark	1	book now	£235	£240
2003	2008 Dec 3 Wed	Bloomsbury	3	book now	£224	£235
2003	2008 Dec 5 Fri	Bayswater	6	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
Full Schedule: See all 99 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: currency

by - trainer Richard platinum contributer [813 posts] (2007 Aug 20 Mon, 15:37) Reply

Hi Marcela

The fastest way to do this is to select the cells that you want to have a currency format, and then hit the MONEY toolbar icon. It is just to the left of the percentage icon.

The other way to do it is to right click on the cells you want to format, and then choose FORMAT CELLS. On the Number tab you will see two options - CURRENCY and ACCOUNTING. they are vry similar, just that ACCOUNTING will align the currency symbol to the left of the column.

Regards

Richard

· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· Fun Things I've Done With Excel
· How Small Businesses Profit from Outside Excel Training
· Advanced level training: Microsoft Excel and the Web
· Microsoft Excel Training - Numerical excellence for all

Excel tip:

Do a fast scroll

In big Excel databases with many records, you can move down thousands of rows super-fast as follows: hold down Shift then click on the scrollbar somewhere below the scrollbar handle. This will move you way down the sheet without your having to use the scrollbar up/down arrows or drag on the scrollbar handle.

View all Excel hints and tips