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