Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel class - Data currency conversion
|
|
|
The UK's most regular 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. |
advanced excel class - Data currency conversion
Resolved · Low Priority · Version Standard
Reply 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
For upcoming training course dates see: Pricing & availability
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
|