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
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
|
