any excel /google wizards

Worried_of_wakefield

Hi, following the demise of my laptop I ended up buying a google chrome book. When I downloaded my monthly Santander bank statement the currency appears as the correct figure but a strange symbol in front rather than a £ sign, sort of an L with a line through it. Ł30.00
This stops the columns formula from working / recognised.
note 1 - the error appears in both .xls download and converted google sheets
note 2 - downloaded .xls credit card statement works fine!
note 3- Wikipedia suggests the symbol is greek and sometimes used in crypto currency
note 4 -when on the cell, the symbol stays with the figures in the function box, ( sterling does not)

Efforts to change the format to sterling don't work. the only method that does work is to 'overwrite' the column of figures then format change to sterling.

edit - just noticed error download is .xlsx ( problem) credit card statement .xls ( ok) still unable to resolve though

many thanks in anticipation

ruperts

Don't know how to stop the symbol appearing but if you want a quick way to get rid of the symbol without having to manually overwrite each cell then you can use find and replace, which can be accessed via Ctrl-f or somewhere on the ribbon. Put it into find and replace mode and set it to find the L symbol and replace it with £ (or a blank if you just want the numbers).

Worried_of_wakefield

Hi ruperts yes stumbled across 'find and replace' 10 mins after my op. that will do until santander come back with a solution, thanks

techquest

I'm sure you already know, you could always download your transactions from the account itself which, as far as I see, does not have the same issue. It's an interesting one though it seems to be a West Slavic (Polish, Kashubian, and Sorbian) letter. So seemingly something to do with a problem at the bank. Though having had a look I don't get this problem happening.

techquest

It looks like it's a Unicode character

U+0141 as a capital,
U+0142 as lower case

Stompa

If you create a simple text file containing just

£10.00

then open it in Excel 2016, you get the £ symbol replaced by a ｣ character.

It's very odd, and didn't happen when I was using an earlier version of Excel.

techquest

Stompa wrote: »

If you create a simple text file containing just

£10.00

then open it in Excel 2016, you get the £ symbol replaced by a ｣ character.

It's very odd, and didn't happen when I was using an earlier version of Excel.

Text file as in note pad or other?

Stompa

techquest wrote: »

Text file as in note pad or other?

Yes, Notepad.