Transform ‚text‘ numbers into numerical values in openoffice.org calc

When pasting data into a Openoffice.org 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.