98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
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
Resolved · Low Priority · Version Standard
Tue 7 Aug 2007, 15:40Delegate 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:01Trainer 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 information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:##### displaying in ExcelWhen you get a series of hash symbols (####) appearing in some of your cells in a spreadsheet, this can make you think that you've make some kind of mistake. |
