I have a spreadsheet that is the output of a SQLite Database on Android. It contains numbers that
have been formatted as text. When I copy the columns into my LibreOffice Spreadsheet I want to make
sure that they are interpreted as numbers.
However they come in as text and the manuals and help at Libre Office are less than useful.
https://help.libreoffice.org/Calc/Converting_Text_to_Numbers implies that this conversion happens
automatically but it sure doesn't
I found reference to a value function, but no information on how to apply it to this data.
I tried just changing the format of the cells to be number but that didn't do anything at all.
I've also attempted various styles of paste special but still it doesn't work.
There has got to be a way to quickly say this text is all really numbers and get it working!
Eugenie (Oogie) McGuire
Desert Weyr http://www.desertweyr.com/
Paonia, CO USA
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
- [libreoffice-users] CALC convert text to numbers · Oogie McGuire
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy