when pasting text into the open office / libre office spread sheet application, the pasted numbers are recognised as text. to convert them,

1. select cells
2. right click — format cells — number
3. menu “edit”: find and replace — from .* to & — check regular expressions

found on http://mynthon.net/howto/-/OpenOffice%20-%20Calc%20-%20convert%20text%20to%20number.txt

This entry was posted on Friday, January 27th, 2012 at 13:18 and is filed under misc. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.