First time here? Check out the FAQ!
answered 2012-07-15 15:12:00 +0200tohuwawohu
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:
100as value (the divisor).
Edit" -> "
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).
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!
Asked: 2012-07-15 09:33:09 +0200
Seen: 76 times
Last updated: Jul 15 '12