Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

At 12:30 14/11/2013 -0800, J Taylor wrote:
Why not use the extension CT2N?
The ' is just removed.

It's worth mentioning that this is a misunderstanding of what is happening. There is no apostrophe in the cell to remove. The apostrophe indicates (in the Input Line) that what may appear to be a number is actually text. After conversion it is no longer appropriate, so it doesn't appear.

If you have "1234" as text, you have a four-byte character string. If you convert that (or the extension does) to a number, you get a (very probably) eight-byte floating point number, consisting of a mantissa and an exponent, each with its sign somehow encoded. There won't be a 1, a 2, a 3, or a 4 anywhere to be seen: only the composite number. That's very different, even though the formatted appearance in a spreadsheet cell could be identical. It's because these cell contents are very different that the apostrophe is necessary as a warning.

Brian Barker

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.