Hello All,
I am getting data from web using Insert > Link to external data.
It brings the data, but the resulting cells do not have the correct format. Therefore, I cannot work with them.
I attach the sample spreadsheet. As a summary;
https://www.finanzen.ch/kursziele/abb
HTML_8
Column E has data like '18.00CHF (text instead of currency)
Column G has data like '31.05.19 (text instead of date in 31.12.99 format)
I tried different combos while inserting the link, ie. different Languages for input (Automatic, Swiss, etc.), and select/unselect detect special numbers option.
v 4.1.5
Any help, please? Thanks in advance.
Best regards,