Categories
Excel Training

Formatting cells in Excel with currency

When I add financial data to my worksheets, I generally type in the content and format the cells afterwards – here are two ways to format cells with currency.

I select my active cells, then I then click on all the cells, right click on format cells, and then go through the dialogue box to select “currency”, then 2 decimal places….I then use the fill handle to copy the format into the remaining column.

format-currency-excel-vba-courses-london
Formatting cells using the Format Cells dialogue box

This works as a process, but I can make this quicker using the currency button in the Home tab.  I select the cells, then go to the Home tab, Number section, and select the currency button.

Home-tab-currency-excel-vba-london
Currency button adds the format in one click. Nice.

I achieve the same result but in a quicker way.

For syllabus information on our courses from introduction to Excel VBA Courses London https://www.stl-training.co.uk/excel-vba-2010-training-course.php

By Richard Bailey

I love what I do; I get to work with an outstanding team to help hundreds of people with their challenges. I’ve learnt a lot from the teams I’ve worked with, no matter the size or industry we all have challenges to overcome, difficult customers, creating a budget or keeping a project on track.