Currency

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

Resolved · Low Priority · Version Standard

Currency

Lisa has attended:
Excel Introduction course

by - delegate Lisa [1 post] (2008 Feb 25 Mon, 16:24) Reply

How do I take the £ off?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	2	book now	£495	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	5	book now	£450	£485
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	4	book now	£475	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	6	book now	£450	£485
2003	2008 Oct 23 Thu + 24 Fri	Southwark	5	book now	£450	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: currency

by - trainer Rich platinum contributer [711 posts] (2008 Feb 26 Tue, 10:48) Reply

Hi Lisa,

Select the cell or column/row you want to remove the £ symbol from.

Go to Format -> Cells...

On the number tab, you'll see the category list. Your cell will most likely have the 'currency' or 'accounting' category selected.

On the right, you'll notice the 'Symbol' drop-down box, and this will be the £ symbol. You can change the drop-down option to be 'none'. Press OK and the £ symbol will be gone.

Hope this helps.

We look forward to asking any more questions you may have.

Kind regards, Rich

· Microsoft Excel's Best Kept Secret
· MS Excel: Excel At Making The Most Of Your Christmas
· Crazy Things People Have Done With Excel
· How to Create Better Excel Spreadsheets: Part Four
· How Excel Training Can Improve Your Company's Sales Process

Please browse our web site to find out more about
excel computer course london and other Microsoft training courses.

Excel tip:

Ctrl+d's double life

Suppose I have a formula in B1 that I wish to copy into B2:B10. I can select B1:B10 then press Ctrl+d to copy the formula down the selected range. Users generally ignore this shortcut in favour of double-clicking on the fill handle to copy down, but Ctrl+d is useful sometimes particularly when there is no data in surrounding columns to guide to how far the double-click method should copy formulae.

Ctrl+d has another use though. When I use the drawing toolbar to draw objects such as Text Boxes, Rectangles and Ovals onto a worksheet, Ctrl+d makes an instant duplicate of selected shapes. For example, I need five Text Boxes the same size. I draw one Text box and adjust it to the size I want, select it, then press Ctrl+d four times to get four identical copies.

View all Excel hints and tips