[111876] in tlhIngan-Hol
Re: [tlhIngan Hol] Out of curiosity..
daemon@ATHENA.MIT.EDU (SuStel)
Fri Feb 22 10:44:04 2019
X-Original-To: tlhingan-hol@lists.kli.org
To: tlhingan-hol@lists.kli.org
From: SuStel <sustel@trimboli.name>
Date: Fri, 22 Feb 2019 10:44:01 -0500
In-Reply-To: <f5451bdc-076a-402f-a4a2-042e9a7d2351@gmx.de>
Reply-To: tlhingan-hol@kli.org
Errors-To: tlhingan-hol-bounces@lists.kli.org
This is a multi-part message in MIME format.
--===============1530765544671183510==
Content-Type: multipart/alternative;
boundary="------------0234E9DC8E613764D19D04B7"
Content-Language: en-US
This is a multi-part message in MIME format.
--------------0234E9DC8E613764D19D04B7
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
On 2/22/2019 10:40 AM, Lieven L. Litaer wrote:
> Am 22.02.2019 um 16:33 schrieb Will Martin:
>> You can start a cell with an apostrophe in Excel by starting it with
>> TWO apostrophes. The second one shows.
>
> Yes, I figured that out already, but that's very annoying if you like
> to make words lists for Klingon vocabulary. It has happened more than
> once that words lost their apostophe due to this reason.
I still find myself replacing lost apostrophes for this very reason.
An apostrophe at the beginning of a cell is treated as a special control
character that forces the rest of the contents of the cell to be read
literally, not interpreted. For instance, something that looks like a
date but isn't can be forced to keep its correct form instead of being
converted into a date.
--
SuStel
http://trimboli.name
--------------0234E9DC8E613764D19D04B7
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">On 2/22/2019 10:40 AM, Lieven L. Litaer
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:f5451bdc-076a-402f-a4a2-042e9a7d2351@gmx.de">Am
22.02.2019 um 16:33 schrieb Will Martin:
<br>
<blockquote type="cite" style="color: #000000;">You can start a
cell with an apostrophe in Excel by starting it with TWO
apostrophes. The second one shows.
<br>
</blockquote>
<br>
Yes, I figured that out already, but that's very annoying if you
like to make words lists for Klingon vocabulary. It has happened
more than once that words lost their apostophe due to this reason.</blockquote>
<p>I still find myself replacing lost apostrophes for this very
reason.</p>
<p>An apostrophe at the beginning of a cell is treated as a special
control character that forces the rest of the contents of the cell
to be read literally, not interpreted. For instance, something
that looks like a date but isn't can be forced to keep its correct
form instead of being converted into a date.<br>
</p>
<pre class="moz-signature" cols="72">--
SuStel
<a class="moz-txt-link-freetext" href="http://trimboli.name">http://trimboli.name</a></pre>
</body>
</html>
--------------0234E9DC8E613764D19D04B7--
--===============1530765544671183510==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
_______________________________________________
tlhIngan-Hol mailing list
tlhIngan-Hol@lists.kli.org
http://lists.kli.org/listinfo.cgi/tlhingan-hol-kli.org
--===============1530765544671183510==--
