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

Leave a Reply