Transform ‚text‘ numbers into numerical values in calc

When pasting data into a Calc Spreadsheet, it may happen that numerical values have been inserted as text values, so arithmetic operations on that values will fail or lead to unexpected results. To transform those numerical values into „plain“ numbers, i recently found a message board thread proposing a simple search/replace using regex: using the search pattern


and the replacement pattern


should do the trick.