Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

advanced excel class - data currency conversion

Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel class - Data currency conversion

advanced excel class - Data currency conversion

ResolvedVersion 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

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.