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

Format

ResolvedVersion 2007

Tue 31 Aug 2010, 17:17 Delegate Abeer said...

Abeer has attended:
Excel Introduction course

Format

how do I change pound sign to dollar sign

Wed 1 Sep 2010, 13:56 Trainer Newson said...

RE: format

To change the pound sign to the dollar sign. Highlight the cells in question. Select Format - Cells from the menu.

Select the number tab and choose currency. When currency is selected the symbol box opposite will be displayed. Click on the arrow next to the symbol box to select the dollar symbol.

Thanks

Newson

Thu 2 Sep 2010, 09:08 Delegate Mike said...

RE: format

its very easily. 1st you highlights the cells, then going to the menu and select the format option, after this go to number tabs option and select currency , then select the dollar sign

College Term Papers

Training courses

98.7 % recommend us

More live stats...

Training information:

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

Format

Format

RE: format

RE: format

Excel articles

Excel tip:

Quickly insert a function