Ask Your Question

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

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

AliZ gravatar image

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

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 +0100

floris v gravatar image

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

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 +0100 )edit

Question Tools

1 follower


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

Seen: 493 times

Last updated: Aug 27 '16