Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training class - Exchange rates/Currency conversion

microsoft excel training class - Exchange rates/Currency conversion

ResolvedVersion Standard

Tue 7 Aug 2007, 15:40 Delegate Julie said...

Julie has attended:
Excel Introduction course
Excel Intermediate course

Exchange rates/Currency conversion

How do I convert the currency of a column? Can I convert a column of totals into 2 different currencies?

Wed 8 Aug 2007, 15:01 Trainer Jacob said...

RE: Exchange rates/Currency conversion

Hi Julie

Right-click the column header you wish to format, then select format cells.

In the format cells dialogue box, select currency.

You can then selct your preferred currency settings.

Note whilst this applies the same setting to all cells in the column, you can change individual cells by right clicking them and repeating the above.

Regards

Jacob

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Recently used file list

Under the File menu, you may find a list of files at the bottom of the menu. These files represent the most recently used Excel spreadsheets. This file list provides a quick way for you to access your files.

You can disable the file list feature of Excel. This is done by

1. Choose Tools > Options menu. You will see the Options dialog box.
2. Ensure the General tab is selected.
3. Make sure the Recently Used File List check box is cleared.
4. Click on OK.

View all Excel hints and tips

microsoft excel training class - Exchange rates/Currency conversion

Exchange rates/Currency conversion

RE: Exchange rates/Currency conversion

Excel articles

Excel tip:

Recently used file list