A bank CSV file has a column with amounts in it prefaced with a £ sign: e.g. £25.60. When I designate that column as currency the £25.60 is left placed in the cell and prefaced with a ’ .
If I manually delete the '£ the numbers move to the right and ar prefaced with £. Doing this down a column of figures is time consuming!
What am I doing wrong when importing the csv file?
The date of each transaction is correct as I can designate that column in date format when importing.
In the import dialog, choose “English(UK)” as import locale and check “Detect special numbers”.