Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenTue, 17 Sep 2013 19:46:07 +020074.5 did not change to 74.500,00https://ask.libreoffice.org/en/question/22728/745-did-not-change-to-7450000/Hello!
I made numbers in the whole A column to . for thousand, and ,00 2 decimals.
Why did last 4 numbers "listen" and first 6 numbers not?
Many thanks!
[![image description](http://i.imgur.com/qXGmjAsl.jpg)](/upfiles/13794284644132356.jpg)
<br><br><sup>Click for a full-resolution image.</sup>
In C column all "listened"!
Whart about E column?
Mayn thansk!
**p.s. Problem is, I do not type it in personallay, I had to import the whole table by "save the link as..."
So, originally, it was:
74.5
and
41497,00
then, I have choosen the format to -1.234,00 and got what you see in the table u p there.
What should I do now to get 74.500,00?
Many thanks!!!**Tue, 17 Sep 2013 16:34:29 +0200https://ask.libreoffice.org/en/question/22728/745-did-not-change-to-7450000/Comment by carnendil for <p>Hello!
I made numbers in the whole A column to . for thousand, and ,00 2 decimals.</p>
<p>Why did last 4 numbers "listen" and first 6 numbers not?
Many thanks!
<a href="/upfiles/13794284644132356.jpg"><img alt="image description" src="http://i.imgur.com/qXGmjAsl.jpg"></a>
<br><br><sup>Click for a full-resolution image.</sup></p>
<p>In C column all "listened"!
Whart about E column?
Mayn thansk!</p>
<p>**p.s. Problem is, I do not type it in personallay, I had to import the whole table by "save the link as..."
So, originally, it was:
74.5
and </p>
<p>41497,00
then, I have choosen the format to -1.234,00 and got what you see in the table u p there.
What should I do now to get 74.500,00?
Many thanks!!!**</p>
https://ask.libreoffice.org/en/question/22728/745-did-not-change-to-7450000/?comment=22735#post-id-22735If I understand correctly, the cells contained values as "74.5" (with a dot) and "41497,00" (with a comma)? I presume your system was originally configured to read the dot as a decimal, am I right? No matter if the downloaded document was created in a computer configured to use either comma or dot as decimal separators, once you open it in your computer, it should show according to your configuration. Are you sure you should be seeing 74 thousand 500? Was the downloaded document an `.ods` file?Tue, 17 Sep 2013 19:08:55 +0200https://ask.libreoffice.org/en/question/22728/745-did-not-change-to-7450000/?comment=22735#post-id-22735Comment by carnendil for <p>Hello!
I made numbers in the whole A column to . for thousand, and ,00 2 decimals.</p>
<p>Why did last 4 numbers "listen" and first 6 numbers not?
Many thanks!
<a href="/upfiles/13794284644132356.jpg"><img alt="image description" src="http://i.imgur.com/qXGmjAsl.jpg"></a>
<br><br><sup>Click for a full-resolution image.</sup></p>
<p>In C column all "listened"!
Whart about E column?
Mayn thansk!</p>
<p>**p.s. Problem is, I do not type it in personallay, I had to import the whole table by "save the link as..."
So, originally, it was:
74.5
and </p>
<p>41497,00
then, I have choosen the format to -1.234,00 and got what you see in the table u p there.
What should I do now to get 74.500,00?
Many thanks!!!**</p>
https://ask.libreoffice.org/en/question/22728/745-did-not-change-to-7450000/?comment=22736#post-id-22736If everything in columns A, C, and E is supposed to be numbers, column E suggests that the dot was the decimal separator in the original document. If that is right, you are supposed to get 74½ instead of 74 thousand 500. Can you upload the original file (if there is not private information on it)?Tue, 17 Sep 2013 19:46:07 +0200https://ask.libreoffice.org/en/question/22728/745-did-not-change-to-7450000/?comment=22736#post-id-22736Answer by carnendil for <p>Hello!
I made numbers in the whole A column to . for thousand, and ,00 2 decimals.</p>
<p>Why did last 4 numbers "listen" and first 6 numbers not?
Many thanks!
<a href="/upfiles/13794284644132356.jpg"><img alt="image description" src="http://i.imgur.com/qXGmjAsl.jpg"></a>
<br><br><sup>Click for a full-resolution image.</sup></p>
<p>In C column all "listened"!
Whart about E column?
Mayn thansk!</p>
<p>**p.s. Problem is, I do not type it in personallay, I had to import the whole table by "save the link as..."
So, originally, it was:
74.5
and </p>
<p>41497,00
then, I have choosen the format to -1.234,00 and got what you see in the table u p there.
What should I do now to get 74.500,00?
Many thanks!!!**</p>
https://ask.libreoffice.org/en/question/22728/745-did-not-change-to-7450000/?answer=22730#post-id-22730If you type "74.5" (*and* your decimal separator is comma -- ","), Calc will take your input as text.
If you then type "41.497", Calc will interpret your input as the number 41 497.
Once you change the format of the cells to use the dot (".") as a separator for thousands and show two decimals, the "text" will still be shown as "74.5", and the number will be shown as "41.497,00".
Try typing "74.500" instead of just "74.5".Tue, 17 Sep 2013 17:37:28 +0200https://ask.libreoffice.org/en/question/22728/745-did-not-change-to-7450000/?answer=22730#post-id-22730