I’ve downloaded my statement from my bank. They use the midata format. I’ve opened it in Excel and the numbers are full of stupid weird A’s. Like this: -£3.00 What is the easiest way to delete them?

I need to preserve the -ve sign but I’m not fussed about the £ symbol.

Thank you!

Find and replace?

I don’t know what midata is. Do they offer any other format like .xls or .csv?

midata is some government scheme to force people who hold your financial data to make it available to you. Only problem is that there doesn’t appear to be any standardisation.

It downloads as .csv

keng38. I owe you a packet of chocolate hobnobs. I was looking for something far more complex!

Sounds like it is using the wrong character encoding. In Excel, go to Data menu, then Import data. Then pick your CSV file, and it has an option for “File origin”. So try setting that for the correct character encoding – Unicode/UTF-8 will probably work.

^^^^^ that.

Sounds like the CSV has been generated with multibyte character encoding.