Warning: Undefined array key "rcommentid" in /homepages/15/d790331382/htdocs/wp-content/plugins/wp-recaptcha/recaptcha.php on line 481

Warning: Undefined array key "rchash" in /homepages/15/d790331382/htdocs/wp-content/plugins/wp-recaptcha/recaptcha.php on line 482

convert text to number in oocalc

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

Leave a Reply


Warning: Undefined variable $user_ID in /homepages/15/d790331382/htdocs/wp-content/themes/thamnos/comments.php on line 65


Warning: Undefined array key "rerror" in /homepages/15/d790331382/htdocs/wp-content/plugins/wp-recaptcha/recaptcha.php on line 401