Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSat, 27 Aug 2016 22:09:16 +0200Is there a way to convert 1K to 1000 in LibreOffice Calc?https://ask.libreoffice.org/en/question/76012/is-there-a-way-to-convert-1k-to-1000-in-libreoffice-calc/ I have a large data set that I need to sum, but the amounts are written in K or M. Is there a way to change these into numerical values so that I can add them? Some of the values are entered as 1.5K or 32.79M, so find and replace with 0's for K or M will not work. Thank you for any advice!Sat, 27 Aug 2016 20:25:48 +0200https://ask.libreoffice.org/en/question/76012/is-there-a-way-to-convert-1k-to-1000-in-libreoffice-calc/Answer by floris v for <p>I have a large data set that I need to sum, but the amounts are written in K or M. Is there a way to change these into numerical values so that I can add them? Some of the values are entered as 1.5K or 32.79M, so find and replace with 0's for K or M will not work. Thank you for any advice!</p>
https://ask.libreoffice.org/en/question/76012/is-there-a-way-to-convert-1k-to-1000-in-libreoffice-calc/?answer=76016#post-id-76016This seems to work. Find/Replace, first deal with the items with k:
In the Search for box, type **^([^k]+)k**
In the Replace box, type **=$1*1000**
Turn on Regular expressions, then Replace all.
Then the same for M, with M instead of k in the search term, and 1000000 instead of 1000.Sat, 27 Aug 2016 21:13:54 +0200https://ask.libreoffice.org/en/question/76012/is-there-a-way-to-convert-1k-to-1000-in-libreoffice-calc/?answer=76016#post-id-76016Comment by AliZ for <p>This seems to work. Find/Replace, first deal with the items with k:</p>
<p>In the Search for box, type <strong>^([^k]+)k</strong></p>
<p>In the Replace box, type <strong>=$1*1000</strong></p>
<p>Turn on Regular expressions, then Replace all. </p>
<p>Then the same for M, with M instead of k in the search term, and 1000000 instead of 1000.</p>
https://ask.libreoffice.org/en/question/76012/is-there-a-way-to-convert-1k-to-1000-in-libreoffice-calc/?comment=76028#post-id-76028This worked great! Thank you!Sat, 27 Aug 2016 22:09:16 +0200https://ask.libreoffice.org/en/question/76012/is-there-a-way-to-convert-1k-to-1000-in-libreoffice-calc/?comment=76028#post-id-76028