On Sun, 17 Nov 2013 13:54:59 -0700
Oogie McGuire <email@example.com> wrote:
What I am used to doing in Excel is copy everything in, then format
the cells to be numbers and they are converted to numbers and my
Really? I'm surprised. I didn't know Excel did this conversion just on
formatting. In LO you can use "Text to Columns" instead, surely?
Or if I know they are text (but there is ABSOLUTELY NO WAY TO SEE
THAT IN LO)
How would you see it in Excel? I recall the display in Excel being the
same as in LO. The only difference between digits that are text and
digits that are numbers is in the justification.
All the discussions about the leading apostrophe are great but I
still can't see it in LO nor can I remove it.
Cell by cell you can remove it, which is just the same as I remember
Excel working. You can see it, and remove it, in the input line per
cell. You can't see it in the actual cells, but you can't in Excel
either, as I recall.
Yes, I got around the problem this time by creating a dummy column as
described many messages ago, but the fact remains that it is neither
easy to change nor easy to see when numbers are formatted as text in
LO and coming from MsOffice this causes lots of problems.
Again, I'm puzzled by the implication that it is easier to see in
Excel. I recall it being the same in Excel as in LO, you see it from
the justification, unless that has been altered for the cells in
As for changing it, it's pretty easy with the "Text to Columns"
functionality; I really can't think of a more straightforward way.
You're right that the paste and multiply trick doesn't work, but that
still has to be done as an extra step doesn't it? You first paste the
contents of the old sheet into the new sheet, then create a dummy cell
holding a single 1, then copy this and paste it over the new cells,
setting it to multiply. Surely this takes just as long, if not longer,
than the "Text to COlumns" method?
I agree the paste and multiply trick should work, but I'm just trying
to understand why you say LO is harder to change the data type, and
especially why you say it is harder to see the data type.
To unsubscribe e-mail to: firstname.lastname@example.org
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
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