I have a sheet with banking data in it and I converted the data to a table (for pivot table). The table was then formatted.

However, when I now copy data into the table, the format is applied to some of the cells, but not to all cells (see attached).

I am copying the data directly from my online banking page on my pc and when I come to paste in excel, I only have one option = Paste.



Any ideas?

Tommy

Attached Images

Screenshot 2023-02-03 103212.jpg (96.6 KB, 10 views)

As you anyway are coping data manually from web page, the simplest way is:
Have an empty sheet, and paste your data there;
Copy data you just pasted, and PasteSpecial them as values into your table (be sure columns there are formatted properly);
Clear all data from another sheet, so they don't mess you up when you get your next batch of data from web.

Thanks ArviLaanemets