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](https://www.stl-training.co.uk/b/exceltraining/files/2012/11/format-currency-excel-vba-courses-london.png)
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.
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