I have a workbook for personal banking purposes. When I log on to my bank, I copy the latest lines of my statement and paste into my workbook. I use Paste Special | Unicode text and my columns are filled appropriately. The only problem is that the last column, i.e. the balance, does not format to two decimal places as I had already set up. How can I automatically paste in the right format, please? Do I need a macro?