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?
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)
A hint: 43374 is the internal representation for date “2018-10-01”.
And how do i get to insert the number 1.3 or 2.5 or any other number with decimals?
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, Number 2 worked like a charm, THNX
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 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.
The number format dialog shows Language Default - English (USA), that’s why I was asking.
