currency

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Currency

Currency

resolvedResolved · Low Priority · Version 2003

Lynne has attended:
Excel Introduction course
Excel Intermediate course

Currency

how to remove or change currency symbol

RE: currency

Hi Lynne
Select the cell, Format, under the number Tab, either Accounting or Currency will give you a currency option.

Good Luck

Tue 9 Dec 2008: Automatically marked as resolved.


 

Excel tip:

Quickly insert a function

In Excel 97 and 2000 it was known as the Paste Function dialog box, these days it's known as the Insert Function dialog box. Regardless, one has to choose Insert|Function. or the fx button to open it up. There is, however, a non-mousey way to get hold of the Insert Function dialog box: press Shift+F3 in a blank cell to open the Insert Function dialog.

Press Shift+F3 after a function name and open bracket to open the Function Arguments dialog. For example, type =VLOOKUP( into a cell and press Shift+F3 to obtain a detailed description of VLOOKUP's arguments.

View all Excel hints and tips


Server loaded in 0.08 secs.