calc number converting

asked 2018-12-20 09:47:54 +0100

givemefive gravatar image

updated 2018-12-20 11:20:41 +0100

My problem is that in spreadsheet when trying to write in a cel "1.1" it converts itself to 43,101.00. Any x.y number i try to write in cell i have the same problem. Where x, y /= 0. I did try to format the cells in all the posible ways. Its always the same. Anyone can help me pls?image description

In the left colum are number inserted manualy: 0.1, 0.2, 0.4, etc and the right colum is made by autofilling (after manualy adding the first 3 cells)

edit retag flag offensive close merge delete


A hint: 43374 is the internal representation for date "2018-10-01".

Mike Kaganski gravatar imageMike Kaganski ( 2018-12-20 10:20:55 +0100 )edit

And how do i get to insert the number 1.3 or 2.5 or any other number with decimals?

givemefive gravatar imagegivemefive ( 2018-12-20 10:54:45 +0100 )edit

Try 1) use comma as decimal separator (most likely this is indicated in your system settings) or 2) go to Tools-Options-Language Settings-Languages and change there "D.M" to, for example "D/M"

JohnSUN gravatar imageJohnSUN ( 2018-12-20 11:34:52 +0100 )edit

JohnSUN, Number 2 worked like a charm, THNX

givemefive gravatar imagegivemefive ( 2018-12-20 11:45:55 +0100 )edit

Out of curiosity: did you change the date acceptance patterns earlier? The default for en-US does not include D.M which when added of course asks for conflicts in a locale that uses . dot as decimal separator.

erAck gravatar imageerAck ( 2018-12-20 18:45:31 +0100 )edit

@erAck Most likely, it uses the locale, which is different from en-US. Some kind of European, judging by the nickname of the author of the question - the Russian.

JohnSUN gravatar imageJohnSUN ( 2018-12-21 10:37:19 +0100 )edit

The number format dialog shows Language Default - English (USA), that's why I was asking.

erAck gravatar imageerAck ( 2018-12-21 12:01:14 +0100 )edit