[SOLVED] LibreOffice Calc and bank statements: numbers as text?
by hish2021 from LinuxQuestions.org on (#5E4F5)
OS: Ubuntu 20.04 (X11) and Arch/sway
I can download my financial statements as .xls files. (.ods isn't an available option.)
When I open them in LibreOffice Calc (version 7.0.4.2 and even older versions), some of the numbers and/or dates are preceded by what look like "single quotes" but these single quotes are visible only in the formula bar or after pressing F2 to edit the cell. Example: '1234 instead of just 1234.
In such cases, the numbers/dates appear to be "text". If I manually remove the "single quote" by editing the cell contents in the formula bar or in the cell itself (by pressing F2), the number/date turns into a genuine number/date.
However, this "single quote" can't be removed using Search & Replace whether I type it or copy/paste it into the search field. I get "Search field" not found.
Using Format > Cells to change the format from Number General to a specific number format also does nothing.
Saving the file as .csv and then reopening that file in Calc gets rid of the "single quotes" but also removes other formatting :(
How do I get rid of these pesky "single quotes" in such a spreadsheet without having to edit each occurrence individually or going the csv route?
(Also, why are these "single quotes" there in the first place?
I can download my financial statements as .xls files. (.ods isn't an available option.)
When I open them in LibreOffice Calc (version 7.0.4.2 and even older versions), some of the numbers and/or dates are preceded by what look like "single quotes" but these single quotes are visible only in the formula bar or after pressing F2 to edit the cell. Example: '1234 instead of just 1234.
In such cases, the numbers/dates appear to be "text". If I manually remove the "single quote" by editing the cell contents in the formula bar or in the cell itself (by pressing F2), the number/date turns into a genuine number/date.
However, this "single quote" can't be removed using Search & Replace whether I type it or copy/paste it into the search field. I get "Search field" not found.
Using Format > Cells to change the format from Number General to a specific number format also does nothing.
Saving the file as .csv and then reopening that file in Calc gets rid of the "single quotes" but also removes other formatting :(
How do I get rid of these pesky "single quotes" in such a spreadsheet without having to edit each occurrence individually or going the csv route?
(Also, why are these "single quotes" there in the first place?