asked 2012-07-15 09:33:09 +0200

Anonymous

I'd like to have Calc automatically insert a decimal point to a number I enter into a cell. For Example: I enter 123456 then hit enter. That number is then converted to 1234.56 automatically.

delete close flag offensive retag edit

1 Answer

Sort by » oldest newest most voted

answered 2012-07-15 15:12:00 +0200

tohuwawohu

1812 ● 13 ● 40

This isn't a trivial task, since you want Calc to insert a value different than the value you've typed. It doesn't matter that it's the result of a trivial calculation (divide input by 100).

I fear you can't tell Calc to "autocorrect" the values you've typed in. But you could use the "Paste special" functionality:

After you've entered the values (for example, 123456), select any empty cell and enter 100 as value (the divisor).
copy that cell holding the divisor;
select the cells holding the values you've entered in the first step;
Hit CTRL+SHIFT+V or Menu "Edit" -> "Paste Special";
In the Options window, select "Divide" from Operations:

image description

As a result, Calc will replace the values you've entered in step 1 by the result of those values divided by 100 (the divisor value from step 2).

link delete flag offensive edit

Comments

A similar solution has one column (or row) as your input (e.g. 123456), and another the result of a formula. For example, if column A is the input, then B1 might have the formula '=A1/100'. The end result is not as clean as tohuwawohu's solution, but requires no work after entering a number.

hunteke ( 2012-07-15 16:39:05 +0200 )edit

@hunteke: good idea!

tohuwawohu ( 2012-07-15 20:03:51 +0200 )edit

Resources

Donate

LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!

Question tools

Stats

Asked: 2012-07-15 09:33:09 +0200

Seen: 76 times

Last updated: Jul 15 '12

Inserting a decimal point