Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenFri, 21 Dec 2018 12:01:14 +0100calc number convertinghttps://ask.libreoffice.org/en/question/176824/calc-number-converting/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](/upfiles/15452972414742872.png)
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)Thu, 20 Dec 2018 09:47:54 +0100https://ask.libreoffice.org/en/question/176824/calc-number-converting/Comment by erAck for <p>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?<img alt="image description" src="/upfiles/15452972414742872.png"></p>
<p>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)</p>
https://ask.libreoffice.org/en/question/176824/calc-number-converting/?comment=176966#post-id-176966The number format dialog shows Language *Default - English (USA)*, that's why I was asking.Fri, 21 Dec 2018 12:01:14 +0100https://ask.libreoffice.org/en/question/176824/calc-number-converting/?comment=176966#post-id-176966Comment by JohnSUN for <p>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?<img alt="image description" src="/upfiles/15452972414742872.png"></p>
<p>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)</p>
https://ask.libreoffice.org/en/question/176824/calc-number-converting/?comment=176954#post-id-176954@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.Fri, 21 Dec 2018 10:37:19 +0100https://ask.libreoffice.org/en/question/176824/calc-number-converting/?comment=176954#post-id-176954Comment by erAck for <p>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?<img alt="image description" src="/upfiles/15452972414742872.png"></p>
<p>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)</p>
https://ask.libreoffice.org/en/question/176824/calc-number-converting/?comment=176875#post-id-176875Out 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.Thu, 20 Dec 2018 18:45:31 +0100https://ask.libreoffice.org/en/question/176824/calc-number-converting/?comment=176875#post-id-176875Comment by givemefive for <p>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?<img alt="image description" src="/upfiles/15452972414742872.png"></p>
<p>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)</p>
https://ask.libreoffice.org/en/question/176824/calc-number-converting/?comment=176830#post-id-176830JohnSUN, Number 2 worked like a charm, THNXThu, 20 Dec 2018 11:45:55 +0100https://ask.libreoffice.org/en/question/176824/calc-number-converting/?comment=176830#post-id-176830Comment by JohnSUN for <p>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?<img alt="image description" src="/upfiles/15452972414742872.png"></p>
<p>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)</p>
https://ask.libreoffice.org/en/question/176824/calc-number-converting/?comment=176829#post-id-176829Try 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"Thu, 20 Dec 2018 11:34:52 +0100https://ask.libreoffice.org/en/question/176824/calc-number-converting/?comment=176829#post-id-176829Comment by givemefive for <p>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?<img alt="image description" src="/upfiles/15452972414742872.png"></p>
<p>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)</p>
https://ask.libreoffice.org/en/question/176824/calc-number-converting/?comment=176828#post-id-176828And how do i get to insert the number 1.3 or 2.5 or any other number with decimals?Thu, 20 Dec 2018 10:54:45 +0100https://ask.libreoffice.org/en/question/176824/calc-number-converting/?comment=176828#post-id-176828Comment by Mike Kaganski for <p>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?<img alt="image description" src="/upfiles/15452972414742872.png"></p>
<p>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)</p>
https://ask.libreoffice.org/en/question/176824/calc-number-converting/?comment=176825#post-id-176825A hint: 43374 is the internal representation for date "2018-10-01".Thu, 20 Dec 2018 10:20:55 +0100https://ask.libreoffice.org/en/question/176824/calc-number-converting/?comment=176825#post-id-176825