Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Cells

Resolved · Low Priority · Version 2010

Reply Tue 24 Aug 2010, 16:34Delegate Simon said...

Simon has attended:
Excel Introduction course

Cells

how do I change cells to $ currency

For upcoming training course dates see: Pricing & availability

Reply Thu 26 Aug 2010, 06:41Trainer Newson said...

RE: cells

Simon sorry for the delay. Highlight the cells in question right click and select format cells from the menu and select the number tab. On the left hand side of the number tab select Currency. When you select currency Excel will display in the sample box opposite what your selection will look like.

Below the sample box you have the decimal places spin button which allows you increase or decrease the decimal places.

The symbol drop-down list box. You need to click the arrow to the right of the box which will allow you to apply different currency formats to the cells you have selected.

Thanks

Hope that helps

Wed 1 Sep 2010: Automatically marked as resolved.

Excel articles

· How to check for and reduce errors in Microsoft Excel
· How to Create Better Excel Spreadsheets: Part Two
· Benefits of learning about Excel charts
· How To Create A Custom List In Excel
· Do You Need To Run Excel 2007 In Compatibility Mode?

Please browse our web site to find out more about
excel-xp-training and other Microsoft training courses.

Excel tip:

Entering text in Multiple Worksheets

If you have a number of worksheets in a workbook that require the same information (data or tables) on each worksheet, this can be done as follows:

Hold down the Ctrl key and click one or more of the additional worksheet tabs (i.e. Sheet2, Sheet3, etc).

In your mainsheet (Sheet1) enter the required data or design a table.

When done 'Click' on the other sheet tabs and you will see that the information entered in Sheet1 is on all the other selected worksheets.

NB Do not forget to deselect the worksheets - otherwise you may add data to the main worksheet and all the selected worksheets will also have that data!

View all Excel hints and tips