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: users+unsubscribe@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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