I copied some table with products and prices from a web page to a Excel (2013) worksheet.
Both the source table and my own Excel are configured with French number settings: a thousand euros and 20 cents is formatted
1 000,20 €
Problem: I cannot get the price column (which contains values from
3 000,00 to
5 000,00, with no currency unit) to be recognized as numbers by Excel.
I have tried all the solutions(1) mentioned here with no success: How to convert text to numbers in Excel ...
(1) except writing a VBA script and retyping the values.
Solutions based on "clicking an error message" are not applicable as there is no error message even after setting the
Number type on the cells.
Is there a solution here ?