<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>