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