title: LibreOffice Calc: How to convert unformatted text to numbers (or other format)
body: <p>How do I paste unformatted text (csv or tab delimited for instance) into LibreOffice Calc and then format it as numbers (without editing every cell by hand). When I paste the text below it puts a ' in front of everything so if I try to convert it to a number it's still text.</p>
  
  <pre><code>Text 0.01% 3% 5.1%
  Asdf 0.2% 4% 6.0%
  </code></pre>
  
  <p>So for example if I paste special that as unformatted text with space delimiters and then convert 0.01% to a number (which would then say 0.0001 if it did what I wanted), it now says '0.01% in the cell.</p>