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”.
Thanks, Villeroy. It worked. What I was doing wrong was to first create a new blank calc file and then open the csv from the new calc file 
When I just opened the csv file from LibreOffice and followed your instructions it worked and dates and financial amounts were correctly shown.
Doesn’t matter…it works the very same way if you… ⇒Sheet⇒insert Sheet from File…
Thanks karolus and noted. One lives and learns!