Ask Your Question

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

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

AliZ 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 close merge delete

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
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 231 times

Last updated: Aug 27 '16