Ask Your Question

Is there a way to convert 1K to 1000 in LibreOffice Calc? [closed]

asked 2016-08-27 20:25:48 +0200

AliZ gravatar image

updated 2020-09-02 01:46:02 +0200

Alex Kemp gravatar image

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!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-02 01:46:08.155351

1 Answer

Sort by » oldest newest most voted

answered 2016-08-27 21:13:54 +0200

floris v gravatar image

updated 2016-08-27 21:29:08 +0200

This 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.

edit flag offensive delete link more


This worked great! Thank you!

AliZ gravatar imageAliZ ( 2016-08-27 22:09:16 +0200 )edit

Question Tools

1 follower


Asked: 2016-08-27 20:25:48 +0200

Seen: 537 times

Last updated: Aug 27 '16