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 » advanced excel class - Data currency conversion
advanced excel class - Data currency conversion
Resolved · Low Priority · Version Standard
Thu 25 Oct 2007, 17:03Delegate Isabella said...
Isabella has attended:
Excel Intermediate course
Excel Advanced course
Data currency conversion
What would be the fasted and most effective way to do a currency conversion on columns of data in a spreadsheet
Sun 28 Oct 2007, 01:17Trainer Rajeev said...
RE: Data currency conversion
Hi Isebella
You seem to be like me who seems to enjoy shortcut keys!! It speeds up and makes us more effective @ work. Thank you for joining our course for Excel Intermediate and I hope that you enjoyed the course.
Select all the cells that you want to apply the currency format to. Please note that you can use CTRL select the non-Contagious cells.
use the following shortcut key:
CTRL+SHIFT+$
This will automatically format all the cells with
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:Changing the Tab Colour of an Excel 2010 WorksheetDid you know you could give the tabs in your worksheet different colours? |
