Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenMon, 17 Dec 2018 18:20:54 +0100formating a cell to currency, adds an unformattable character to front of cell value. How do I correct this.https://ask.libreoffice.org/en/question/176536/formating-a-cell-to-currency-adds-an-unformattable-character-to-front-of-cell-value-how-do-i-correct-this/I downloaded a spread sheet from fidelity, and the values are interpreted as text. I want to sum the column, so I highlighted the entire column, and applied the currency formatting. The value within the cell still remains as it was, and the value has a ' character at the start of it.
What am I doing wrong? Or is this a bug?
for instance the value in the cell is $1139.33 and is formatted as text. Trying to change it to currency, the number does not change in appearance (nor shifted to be left aligned) but in the formula bar, the number appears as '$1139.33
It is not able to be added to a formula for summing unless the leading ' is removed.
What's with that? Mon, 17 Dec 2018 18:11:57 +0100https://ask.libreoffice.org/en/question/176536/formating-a-cell-to-currency-adds-an-unformattable-character-to-front-of-cell-value-how-do-i-correct-this/Answer by erAck for <p>I downloaded a spread sheet from fidelity, and the values are interpreted as text. I want to sum the column, so I highlighted the entire column, and applied the currency formatting. The value within the cell still remains as it was, and the value has a ' character at the start of it.</p>
<p>What am I doing wrong? Or is this a bug? </p>
<p>for instance the value in the cell is $1139.33 and is formatted as text. Trying to change it to currency, the number does not change in appearance (nor shifted to be left aligned) but in the formula bar, the number appears as '$1139.33 </p>
<p>It is not able to be added to a formula for summing unless the leading ' is removed.</p>
<p>What's with that? </p>
https://ask.libreoffice.org/en/question/176536/formating-a-cell-to-currency-adds-an-unformattable-character-to-front-of-cell-value-how-do-i-correct-this/?answer=176538#post-id-176538See [this FAQ](https://wiki.documentfoundation.org/Faq/Calc/How_to_convert_number_text_to_numeric_data).Mon, 17 Dec 2018 18:20:54 +0100https://ask.libreoffice.org/en/question/176536/formating-a-cell-to-currency-adds-an-unformattable-character-to-front-of-cell-value-how-do-i-correct-this/?answer=176538#post-id-176538